package com.zhongwang.mms.gen.entity;

import java.util.ArrayList;
import java.util.Date;
import java.util.Iterator;
import java.util.List;

public class HAdjustmentApplyDetailExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public HAdjustmentApplyDetailExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        protected void addCriterionForJDBCDate(String condition, Date value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            addCriterion(condition, new java.sql.Date(value.getTime()), property);
        }

        protected void addCriterionForJDBCDate(String condition, List<Date> values, String property) {
            if (values == null || values.size() == 0) {
                throw new RuntimeException("Value list for " + property + " cannot be null or empty");
            }
            List<java.sql.Date> dateList = new ArrayList<java.sql.Date>();
            Iterator<Date> iter = values.iterator();
            while (iter.hasNext()) {
                dateList.add(new java.sql.Date(iter.next().getTime()));
            }
            addCriterion(condition, dateList, property);
        }

        protected void addCriterionForJDBCDate(String condition, Date value1, Date value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            addCriterion(condition, new java.sql.Date(value1.getTime()), new java.sql.Date(value2.getTime()), property);
        }

        public Criteria andAadIdIsNull() {
            addCriterion("aad_id is null");
            return (Criteria) this;
        }

        public Criteria andAadIdIsNotNull() {
            addCriterion("aad_id is not null");
            return (Criteria) this;
        }

        public Criteria andAadIdEqualTo(Integer value) {
            addCriterion("aad_id =", value, "aadId");
            return (Criteria) this;
        }

        public Criteria andAadIdNotEqualTo(Integer value) {
            addCriterion("aad_id <>", value, "aadId");
            return (Criteria) this;
        }

        public Criteria andAadIdGreaterThan(Integer value) {
            addCriterion("aad_id >", value, "aadId");
            return (Criteria) this;
        }

        public Criteria andAadIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("aad_id >=", value, "aadId");
            return (Criteria) this;
        }

        public Criteria andAadIdLessThan(Integer value) {
            addCriterion("aad_id <", value, "aadId");
            return (Criteria) this;
        }

        public Criteria andAadIdLessThanOrEqualTo(Integer value) {
            addCriterion("aad_id <=", value, "aadId");
            return (Criteria) this;
        }

        public Criteria andAadIdIn(List<Integer> values) {
            addCriterion("aad_id in", values, "aadId");
            return (Criteria) this;
        }

        public Criteria andAadIdNotIn(List<Integer> values) {
            addCriterion("aad_id not in", values, "aadId");
            return (Criteria) this;
        }

        public Criteria andAadIdBetween(Integer value1, Integer value2) {
            addCriterion("aad_id between", value1, value2, "aadId");
            return (Criteria) this;
        }

        public Criteria andAadIdNotBetween(Integer value1, Integer value2) {
            addCriterion("aad_id not between", value1, value2, "aadId");
            return (Criteria) this;
        }

        public Criteria andAadBeforeMatCodeIsNull() {
            addCriterion("aad_before_mat_code is null");
            return (Criteria) this;
        }

        public Criteria andAadBeforeMatCodeIsNotNull() {
            addCriterion("aad_before_mat_code is not null");
            return (Criteria) this;
        }

        public Criteria andAadBeforeMatCodeEqualTo(String value) {
            addCriterion("aad_before_mat_code =", value, "aadBeforeMatCode");
            return (Criteria) this;
        }

        public Criteria andAadBeforeMatCodeNotEqualTo(String value) {
            addCriterion("aad_before_mat_code <>", value, "aadBeforeMatCode");
            return (Criteria) this;
        }

        public Criteria andAadBeforeMatCodeGreaterThan(String value) {
            addCriterion("aad_before_mat_code >", value, "aadBeforeMatCode");
            return (Criteria) this;
        }

        public Criteria andAadBeforeMatCodeGreaterThanOrEqualTo(String value) {
            addCriterion("aad_before_mat_code >=", value, "aadBeforeMatCode");
            return (Criteria) this;
        }

        public Criteria andAadBeforeMatCodeLessThan(String value) {
            addCriterion("aad_before_mat_code <", value, "aadBeforeMatCode");
            return (Criteria) this;
        }

        public Criteria andAadBeforeMatCodeLessThanOrEqualTo(String value) {
            addCriterion("aad_before_mat_code <=", value, "aadBeforeMatCode");
            return (Criteria) this;
        }

        public Criteria andAadBeforeMatCodeLike(String value) {
            addCriterion("aad_before_mat_code like", value, "aadBeforeMatCode");
            return (Criteria) this;
        }

        public Criteria andAadBeforeMatCodeNotLike(String value) {
            addCriterion("aad_before_mat_code not like", value, "aadBeforeMatCode");
            return (Criteria) this;
        }

        public Criteria andAadBeforeMatCodeIn(List<String> values) {
            addCriterion("aad_before_mat_code in", values, "aadBeforeMatCode");
            return (Criteria) this;
        }

        public Criteria andAadBeforeMatCodeNotIn(List<String> values) {
            addCriterion("aad_before_mat_code not in", values, "aadBeforeMatCode");
            return (Criteria) this;
        }

        public Criteria andAadBeforeMatCodeBetween(String value1, String value2) {
            addCriterion("aad_before_mat_code between", value1, value2, "aadBeforeMatCode");
            return (Criteria) this;
        }

        public Criteria andAadBeforeMatCodeNotBetween(String value1, String value2) {
            addCriterion("aad_before_mat_code not between", value1, value2, "aadBeforeMatCode");
            return (Criteria) this;
        }

        public Criteria andAadBeforeMatNameIsNull() {
            addCriterion("aad_before_mat_name is null");
            return (Criteria) this;
        }

        public Criteria andAadBeforeMatNameIsNotNull() {
            addCriterion("aad_before_mat_name is not null");
            return (Criteria) this;
        }

        public Criteria andAadBeforeMatNameEqualTo(String value) {
            addCriterion("aad_before_mat_name =", value, "aadBeforeMatName");
            return (Criteria) this;
        }

        public Criteria andAadBeforeMatNameNotEqualTo(String value) {
            addCriterion("aad_before_mat_name <>", value, "aadBeforeMatName");
            return (Criteria) this;
        }

        public Criteria andAadBeforeMatNameGreaterThan(String value) {
            addCriterion("aad_before_mat_name >", value, "aadBeforeMatName");
            return (Criteria) this;
        }

        public Criteria andAadBeforeMatNameGreaterThanOrEqualTo(String value) {
            addCriterion("aad_before_mat_name >=", value, "aadBeforeMatName");
            return (Criteria) this;
        }

        public Criteria andAadBeforeMatNameLessThan(String value) {
            addCriterion("aad_before_mat_name <", value, "aadBeforeMatName");
            return (Criteria) this;
        }

        public Criteria andAadBeforeMatNameLessThanOrEqualTo(String value) {
            addCriterion("aad_before_mat_name <=", value, "aadBeforeMatName");
            return (Criteria) this;
        }

        public Criteria andAadBeforeMatNameLike(String value) {
            addCriterion("aad_before_mat_name like", value, "aadBeforeMatName");
            return (Criteria) this;
        }

        public Criteria andAadBeforeMatNameNotLike(String value) {
            addCriterion("aad_before_mat_name not like", value, "aadBeforeMatName");
            return (Criteria) this;
        }

        public Criteria andAadBeforeMatNameIn(List<String> values) {
            addCriterion("aad_before_mat_name in", values, "aadBeforeMatName");
            return (Criteria) this;
        }

        public Criteria andAadBeforeMatNameNotIn(List<String> values) {
            addCriterion("aad_before_mat_name not in", values, "aadBeforeMatName");
            return (Criteria) this;
        }

        public Criteria andAadBeforeMatNameBetween(String value1, String value2) {
            addCriterion("aad_before_mat_name between", value1, value2, "aadBeforeMatName");
            return (Criteria) this;
        }

        public Criteria andAadBeforeMatNameNotBetween(String value1, String value2) {
            addCriterion("aad_before_mat_name not between", value1, value2, "aadBeforeMatName");
            return (Criteria) this;
        }

        public Criteria andAadBeforeProjectCodeIsNull() {
            addCriterion("aad_before_project_code is null");
            return (Criteria) this;
        }

        public Criteria andAadBeforeProjectCodeIsNotNull() {
            addCriterion("aad_before_project_code is not null");
            return (Criteria) this;
        }

        public Criteria andAadBeforeProjectCodeEqualTo(String value) {
            addCriterion("aad_before_project_code =", value, "aadBeforeProjectCode");
            return (Criteria) this;
        }

        public Criteria andAadBeforeProjectCodeNotEqualTo(String value) {
            addCriterion("aad_before_project_code <>", value, "aadBeforeProjectCode");
            return (Criteria) this;
        }

        public Criteria andAadBeforeProjectCodeGreaterThan(String value) {
            addCriterion("aad_before_project_code >", value, "aadBeforeProjectCode");
            return (Criteria) this;
        }

        public Criteria andAadBeforeProjectCodeGreaterThanOrEqualTo(String value) {
            addCriterion("aad_before_project_code >=", value, "aadBeforeProjectCode");
            return (Criteria) this;
        }

        public Criteria andAadBeforeProjectCodeLessThan(String value) {
            addCriterion("aad_before_project_code <", value, "aadBeforeProjectCode");
            return (Criteria) this;
        }

        public Criteria andAadBeforeProjectCodeLessThanOrEqualTo(String value) {
            addCriterion("aad_before_project_code <=", value, "aadBeforeProjectCode");
            return (Criteria) this;
        }

        public Criteria andAadBeforeProjectCodeLike(String value) {
            addCriterion("aad_before_project_code like", value, "aadBeforeProjectCode");
            return (Criteria) this;
        }

        public Criteria andAadBeforeProjectCodeNotLike(String value) {
            addCriterion("aad_before_project_code not like", value, "aadBeforeProjectCode");
            return (Criteria) this;
        }

        public Criteria andAadBeforeProjectCodeIn(List<String> values) {
            addCriterion("aad_before_project_code in", values, "aadBeforeProjectCode");
            return (Criteria) this;
        }

        public Criteria andAadBeforeProjectCodeNotIn(List<String> values) {
            addCriterion("aad_before_project_code not in", values, "aadBeforeProjectCode");
            return (Criteria) this;
        }

        public Criteria andAadBeforeProjectCodeBetween(String value1, String value2) {
            addCriterion("aad_before_project_code between", value1, value2, "aadBeforeProjectCode");
            return (Criteria) this;
        }

        public Criteria andAadBeforeProjectCodeNotBetween(String value1, String value2) {
            addCriterion("aad_before_project_code not between", value1, value2, "aadBeforeProjectCode");
            return (Criteria) this;
        }

        public Criteria andAadBeforeProjectNameIsNull() {
            addCriterion("aad_before_project_name is null");
            return (Criteria) this;
        }

        public Criteria andAadBeforeProjectNameIsNotNull() {
            addCriterion("aad_before_project_name is not null");
            return (Criteria) this;
        }

        public Criteria andAadBeforeProjectNameEqualTo(String value) {
            addCriterion("aad_before_project_name =", value, "aadBeforeProjectName");
            return (Criteria) this;
        }

        public Criteria andAadBeforeProjectNameNotEqualTo(String value) {
            addCriterion("aad_before_project_name <>", value, "aadBeforeProjectName");
            return (Criteria) this;
        }

        public Criteria andAadBeforeProjectNameGreaterThan(String value) {
            addCriterion("aad_before_project_name >", value, "aadBeforeProjectName");
            return (Criteria) this;
        }

        public Criteria andAadBeforeProjectNameGreaterThanOrEqualTo(String value) {
            addCriterion("aad_before_project_name >=", value, "aadBeforeProjectName");
            return (Criteria) this;
        }

        public Criteria andAadBeforeProjectNameLessThan(String value) {
            addCriterion("aad_before_project_name <", value, "aadBeforeProjectName");
            return (Criteria) this;
        }

        public Criteria andAadBeforeProjectNameLessThanOrEqualTo(String value) {
            addCriterion("aad_before_project_name <=", value, "aadBeforeProjectName");
            return (Criteria) this;
        }

        public Criteria andAadBeforeProjectNameLike(String value) {
            addCriterion("aad_before_project_name like", value, "aadBeforeProjectName");
            return (Criteria) this;
        }

        public Criteria andAadBeforeProjectNameNotLike(String value) {
            addCriterion("aad_before_project_name not like", value, "aadBeforeProjectName");
            return (Criteria) this;
        }

        public Criteria andAadBeforeProjectNameIn(List<String> values) {
            addCriterion("aad_before_project_name in", values, "aadBeforeProjectName");
            return (Criteria) this;
        }

        public Criteria andAadBeforeProjectNameNotIn(List<String> values) {
            addCriterion("aad_before_project_name not in", values, "aadBeforeProjectName");
            return (Criteria) this;
        }

        public Criteria andAadBeforeProjectNameBetween(String value1, String value2) {
            addCriterion("aad_before_project_name between", value1, value2, "aadBeforeProjectName");
            return (Criteria) this;
        }

        public Criteria andAadBeforeProjectNameNotBetween(String value1, String value2) {
            addCriterion("aad_before_project_name not between", value1, value2, "aadBeforeProjectName");
            return (Criteria) this;
        }

        public Criteria andAadBeforePartIsNull() {
            addCriterion("aad_before_part is null");
            return (Criteria) this;
        }

        public Criteria andAadBeforePartIsNotNull() {
            addCriterion("aad_before_part is not null");
            return (Criteria) this;
        }

        public Criteria andAadBeforePartEqualTo(String value) {
            addCriterion("aad_before_part =", value, "aadBeforePart");
            return (Criteria) this;
        }

        public Criteria andAadBeforePartNotEqualTo(String value) {
            addCriterion("aad_before_part <>", value, "aadBeforePart");
            return (Criteria) this;
        }

        public Criteria andAadBeforePartGreaterThan(String value) {
            addCriterion("aad_before_part >", value, "aadBeforePart");
            return (Criteria) this;
        }

        public Criteria andAadBeforePartGreaterThanOrEqualTo(String value) {
            addCriterion("aad_before_part >=", value, "aadBeforePart");
            return (Criteria) this;
        }

        public Criteria andAadBeforePartLessThan(String value) {
            addCriterion("aad_before_part <", value, "aadBeforePart");
            return (Criteria) this;
        }

        public Criteria andAadBeforePartLessThanOrEqualTo(String value) {
            addCriterion("aad_before_part <=", value, "aadBeforePart");
            return (Criteria) this;
        }

        public Criteria andAadBeforePartLike(String value) {
            addCriterion("aad_before_part like", value, "aadBeforePart");
            return (Criteria) this;
        }

        public Criteria andAadBeforePartNotLike(String value) {
            addCriterion("aad_before_part not like", value, "aadBeforePart");
            return (Criteria) this;
        }

        public Criteria andAadBeforePartIn(List<String> values) {
            addCriterion("aad_before_part in", values, "aadBeforePart");
            return (Criteria) this;
        }

        public Criteria andAadBeforePartNotIn(List<String> values) {
            addCriterion("aad_before_part not in", values, "aadBeforePart");
            return (Criteria) this;
        }

        public Criteria andAadBeforePartBetween(String value1, String value2) {
            addCriterion("aad_before_part between", value1, value2, "aadBeforePart");
            return (Criteria) this;
        }

        public Criteria andAadBeforePartNotBetween(String value1, String value2) {
            addCriterion("aad_before_part not between", value1, value2, "aadBeforePart");
            return (Criteria) this;
        }

        public Criteria andAadBeforeDrawingNoIsNull() {
            addCriterion("aad_before_drawing_no is null");
            return (Criteria) this;
        }

        public Criteria andAadBeforeDrawingNoIsNotNull() {
            addCriterion("aad_before_drawing_no is not null");
            return (Criteria) this;
        }

        public Criteria andAadBeforeDrawingNoEqualTo(String value) {
            addCriterion("aad_before_drawing_no =", value, "aadBeforeDrawingNo");
            return (Criteria) this;
        }

        public Criteria andAadBeforeDrawingNoNotEqualTo(String value) {
            addCriterion("aad_before_drawing_no <>", value, "aadBeforeDrawingNo");
            return (Criteria) this;
        }

        public Criteria andAadBeforeDrawingNoGreaterThan(String value) {
            addCriterion("aad_before_drawing_no >", value, "aadBeforeDrawingNo");
            return (Criteria) this;
        }

        public Criteria andAadBeforeDrawingNoGreaterThanOrEqualTo(String value) {
            addCriterion("aad_before_drawing_no >=", value, "aadBeforeDrawingNo");
            return (Criteria) this;
        }

        public Criteria andAadBeforeDrawingNoLessThan(String value) {
            addCriterion("aad_before_drawing_no <", value, "aadBeforeDrawingNo");
            return (Criteria) this;
        }

        public Criteria andAadBeforeDrawingNoLessThanOrEqualTo(String value) {
            addCriterion("aad_before_drawing_no <=", value, "aadBeforeDrawingNo");
            return (Criteria) this;
        }

        public Criteria andAadBeforeDrawingNoLike(String value) {
            addCriterion("aad_before_drawing_no like", value, "aadBeforeDrawingNo");
            return (Criteria) this;
        }

        public Criteria andAadBeforeDrawingNoNotLike(String value) {
            addCriterion("aad_before_drawing_no not like", value, "aadBeforeDrawingNo");
            return (Criteria) this;
        }

        public Criteria andAadBeforeDrawingNoIn(List<String> values) {
            addCriterion("aad_before_drawing_no in", values, "aadBeforeDrawingNo");
            return (Criteria) this;
        }

        public Criteria andAadBeforeDrawingNoNotIn(List<String> values) {
            addCriterion("aad_before_drawing_no not in", values, "aadBeforeDrawingNo");
            return (Criteria) this;
        }

        public Criteria andAadBeforeDrawingNoBetween(String value1, String value2) {
            addCriterion("aad_before_drawing_no between", value1, value2, "aadBeforeDrawingNo");
            return (Criteria) this;
        }

        public Criteria andAadBeforeDrawingNoNotBetween(String value1, String value2) {
            addCriterion("aad_before_drawing_no not between", value1, value2, "aadBeforeDrawingNo");
            return (Criteria) this;
        }

        public Criteria andAadBeforeMakingPiecesStatusIsNull() {
            addCriterion("aad_before_making_pieces_status is null");
            return (Criteria) this;
        }

        public Criteria andAadBeforeMakingPiecesStatusIsNotNull() {
            addCriterion("aad_before_making_pieces_status is not null");
            return (Criteria) this;
        }

        public Criteria andAadBeforeMakingPiecesStatusEqualTo(String value) {
            addCriterion("aad_before_making_pieces_status =", value, "aadBeforeMakingPiecesStatus");
            return (Criteria) this;
        }

        public Criteria andAadBeforeMakingPiecesStatusNotEqualTo(String value) {
            addCriterion("aad_before_making_pieces_status <>", value, "aadBeforeMakingPiecesStatus");
            return (Criteria) this;
        }

        public Criteria andAadBeforeMakingPiecesStatusGreaterThan(String value) {
            addCriterion("aad_before_making_pieces_status >", value, "aadBeforeMakingPiecesStatus");
            return (Criteria) this;
        }

        public Criteria andAadBeforeMakingPiecesStatusGreaterThanOrEqualTo(String value) {
            addCriterion("aad_before_making_pieces_status >=", value, "aadBeforeMakingPiecesStatus");
            return (Criteria) this;
        }

        public Criteria andAadBeforeMakingPiecesStatusLessThan(String value) {
            addCriterion("aad_before_making_pieces_status <", value, "aadBeforeMakingPiecesStatus");
            return (Criteria) this;
        }

        public Criteria andAadBeforeMakingPiecesStatusLessThanOrEqualTo(String value) {
            addCriterion("aad_before_making_pieces_status <=", value, "aadBeforeMakingPiecesStatus");
            return (Criteria) this;
        }

        public Criteria andAadBeforeMakingPiecesStatusLike(String value) {
            addCriterion("aad_before_making_pieces_status like", value, "aadBeforeMakingPiecesStatus");
            return (Criteria) this;
        }

        public Criteria andAadBeforeMakingPiecesStatusNotLike(String value) {
            addCriterion("aad_before_making_pieces_status not like", value, "aadBeforeMakingPiecesStatus");
            return (Criteria) this;
        }

        public Criteria andAadBeforeMakingPiecesStatusIn(List<String> values) {
            addCriterion("aad_before_making_pieces_status in", values, "aadBeforeMakingPiecesStatus");
            return (Criteria) this;
        }

        public Criteria andAadBeforeMakingPiecesStatusNotIn(List<String> values) {
            addCriterion("aad_before_making_pieces_status not in", values, "aadBeforeMakingPiecesStatus");
            return (Criteria) this;
        }

        public Criteria andAadBeforeMakingPiecesStatusBetween(String value1, String value2) {
            addCriterion("aad_before_making_pieces_status between", value1, value2, "aadBeforeMakingPiecesStatus");
            return (Criteria) this;
        }

        public Criteria andAadBeforeMakingPiecesStatusNotBetween(String value1, String value2) {
            addCriterion("aad_before_making_pieces_status not between", value1, value2, "aadBeforeMakingPiecesStatus");
            return (Criteria) this;
        }

        public Criteria andAadBeforeBrandIsNull() {
            addCriterion("aad_before_brand is null");
            return (Criteria) this;
        }

        public Criteria andAadBeforeBrandIsNotNull() {
            addCriterion("aad_before_brand is not null");
            return (Criteria) this;
        }

        public Criteria andAadBeforeBrandEqualTo(String value) {
            addCriterion("aad_before_brand =", value, "aadBeforeBrand");
            return (Criteria) this;
        }

        public Criteria andAadBeforeBrandNotEqualTo(String value) {
            addCriterion("aad_before_brand <>", value, "aadBeforeBrand");
            return (Criteria) this;
        }

        public Criteria andAadBeforeBrandGreaterThan(String value) {
            addCriterion("aad_before_brand >", value, "aadBeforeBrand");
            return (Criteria) this;
        }

        public Criteria andAadBeforeBrandGreaterThanOrEqualTo(String value) {
            addCriterion("aad_before_brand >=", value, "aadBeforeBrand");
            return (Criteria) this;
        }

        public Criteria andAadBeforeBrandLessThan(String value) {
            addCriterion("aad_before_brand <", value, "aadBeforeBrand");
            return (Criteria) this;
        }

        public Criteria andAadBeforeBrandLessThanOrEqualTo(String value) {
            addCriterion("aad_before_brand <=", value, "aadBeforeBrand");
            return (Criteria) this;
        }

        public Criteria andAadBeforeBrandLike(String value) {
            addCriterion("aad_before_brand like", value, "aadBeforeBrand");
            return (Criteria) this;
        }

        public Criteria andAadBeforeBrandNotLike(String value) {
            addCriterion("aad_before_brand not like", value, "aadBeforeBrand");
            return (Criteria) this;
        }

        public Criteria andAadBeforeBrandIn(List<String> values) {
            addCriterion("aad_before_brand in", values, "aadBeforeBrand");
            return (Criteria) this;
        }

        public Criteria andAadBeforeBrandNotIn(List<String> values) {
            addCriterion("aad_before_brand not in", values, "aadBeforeBrand");
            return (Criteria) this;
        }

        public Criteria andAadBeforeBrandBetween(String value1, String value2) {
            addCriterion("aad_before_brand between", value1, value2, "aadBeforeBrand");
            return (Criteria) this;
        }

        public Criteria andAadBeforeBrandNotBetween(String value1, String value2) {
            addCriterion("aad_before_brand not between", value1, value2, "aadBeforeBrand");
            return (Criteria) this;
        }

        public Criteria andAadBeforeWhiIdIsNull() {
            addCriterion("aad_before_whi_id is null");
            return (Criteria) this;
        }

        public Criteria andAadBeforeWhiIdIsNotNull() {
            addCriterion("aad_before_whi_id is not null");
            return (Criteria) this;
        }

        public Criteria andAadBeforeWhiIdEqualTo(Integer value) {
            addCriterion("aad_before_whi_id =", value, "aadBeforeWhiId");
            return (Criteria) this;
        }

        public Criteria andAadBeforeWhiIdNotEqualTo(Integer value) {
            addCriterion("aad_before_whi_id <>", value, "aadBeforeWhiId");
            return (Criteria) this;
        }

        public Criteria andAadBeforeWhiIdGreaterThan(Integer value) {
            addCriterion("aad_before_whi_id >", value, "aadBeforeWhiId");
            return (Criteria) this;
        }

        public Criteria andAadBeforeWhiIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("aad_before_whi_id >=", value, "aadBeforeWhiId");
            return (Criteria) this;
        }

        public Criteria andAadBeforeWhiIdLessThan(Integer value) {
            addCriterion("aad_before_whi_id <", value, "aadBeforeWhiId");
            return (Criteria) this;
        }

        public Criteria andAadBeforeWhiIdLessThanOrEqualTo(Integer value) {
            addCriterion("aad_before_whi_id <=", value, "aadBeforeWhiId");
            return (Criteria) this;
        }

        public Criteria andAadBeforeWhiIdIn(List<Integer> values) {
            addCriterion("aad_before_whi_id in", values, "aadBeforeWhiId");
            return (Criteria) this;
        }

        public Criteria andAadBeforeWhiIdNotIn(List<Integer> values) {
            addCriterion("aad_before_whi_id not in", values, "aadBeforeWhiId");
            return (Criteria) this;
        }

        public Criteria andAadBeforeWhiIdBetween(Integer value1, Integer value2) {
            addCriterion("aad_before_whi_id between", value1, value2, "aadBeforeWhiId");
            return (Criteria) this;
        }

        public Criteria andAadBeforeWhiIdNotBetween(Integer value1, Integer value2) {
            addCriterion("aad_before_whi_id not between", value1, value2, "aadBeforeWhiId");
            return (Criteria) this;
        }

        public Criteria andAadBeforeSapMatCodeIsNull() {
            addCriterion("aad_before_sap_mat_code is null");
            return (Criteria) this;
        }

        public Criteria andAadBeforeSapMatCodeIsNotNull() {
            addCriterion("aad_before_sap_mat_code is not null");
            return (Criteria) this;
        }

        public Criteria andAadBeforeSapMatCodeEqualTo(String value) {
            addCriterion("aad_before_sap_mat_code =", value, "aadBeforeSapMatCode");
            return (Criteria) this;
        }

        public Criteria andAadBeforeSapMatCodeNotEqualTo(String value) {
            addCriterion("aad_before_sap_mat_code <>", value, "aadBeforeSapMatCode");
            return (Criteria) this;
        }

        public Criteria andAadBeforeSapMatCodeGreaterThan(String value) {
            addCriterion("aad_before_sap_mat_code >", value, "aadBeforeSapMatCode");
            return (Criteria) this;
        }

        public Criteria andAadBeforeSapMatCodeGreaterThanOrEqualTo(String value) {
            addCriterion("aad_before_sap_mat_code >=", value, "aadBeforeSapMatCode");
            return (Criteria) this;
        }

        public Criteria andAadBeforeSapMatCodeLessThan(String value) {
            addCriterion("aad_before_sap_mat_code <", value, "aadBeforeSapMatCode");
            return (Criteria) this;
        }

        public Criteria andAadBeforeSapMatCodeLessThanOrEqualTo(String value) {
            addCriterion("aad_before_sap_mat_code <=", value, "aadBeforeSapMatCode");
            return (Criteria) this;
        }

        public Criteria andAadBeforeSapMatCodeLike(String value) {
            addCriterion("aad_before_sap_mat_code like", value, "aadBeforeSapMatCode");
            return (Criteria) this;
        }

        public Criteria andAadBeforeSapMatCodeNotLike(String value) {
            addCriterion("aad_before_sap_mat_code not like", value, "aadBeforeSapMatCode");
            return (Criteria) this;
        }

        public Criteria andAadBeforeSapMatCodeIn(List<String> values) {
            addCriterion("aad_before_sap_mat_code in", values, "aadBeforeSapMatCode");
            return (Criteria) this;
        }

        public Criteria andAadBeforeSapMatCodeNotIn(List<String> values) {
            addCriterion("aad_before_sap_mat_code not in", values, "aadBeforeSapMatCode");
            return (Criteria) this;
        }

        public Criteria andAadBeforeSapMatCodeBetween(String value1, String value2) {
            addCriterion("aad_before_sap_mat_code between", value1, value2, "aadBeforeSapMatCode");
            return (Criteria) this;
        }

        public Criteria andAadBeforeSapMatCodeNotBetween(String value1, String value2) {
            addCriterion("aad_before_sap_mat_code not between", value1, value2, "aadBeforeSapMatCode");
            return (Criteria) this;
        }

        public Criteria andAadBeforeNumIsNull() {
            addCriterion("aad_before_num is null");
            return (Criteria) this;
        }

        public Criteria andAadBeforeNumIsNotNull() {
            addCriterion("aad_before_num is not null");
            return (Criteria) this;
        }

        public Criteria andAadBeforeNumEqualTo(Double value) {
            addCriterion("aad_before_num =", value, "aadBeforeNum");
            return (Criteria) this;
        }

        public Criteria andAadBeforeNumNotEqualTo(Double value) {
            addCriterion("aad_before_num <>", value, "aadBeforeNum");
            return (Criteria) this;
        }

        public Criteria andAadBeforeNumGreaterThan(Double value) {
            addCriterion("aad_before_num >", value, "aadBeforeNum");
            return (Criteria) this;
        }

        public Criteria andAadBeforeNumGreaterThanOrEqualTo(Double value) {
            addCriterion("aad_before_num >=", value, "aadBeforeNum");
            return (Criteria) this;
        }

        public Criteria andAadBeforeNumLessThan(Double value) {
            addCriterion("aad_before_num <", value, "aadBeforeNum");
            return (Criteria) this;
        }

        public Criteria andAadBeforeNumLessThanOrEqualTo(Double value) {
            addCriterion("aad_before_num <=", value, "aadBeforeNum");
            return (Criteria) this;
        }

        public Criteria andAadBeforeNumIn(List<Double> values) {
            addCriterion("aad_before_num in", values, "aadBeforeNum");
            return (Criteria) this;
        }

        public Criteria andAadBeforeNumNotIn(List<Double> values) {
            addCriterion("aad_before_num not in", values, "aadBeforeNum");
            return (Criteria) this;
        }

        public Criteria andAadBeforeNumBetween(Double value1, Double value2) {
            addCriterion("aad_before_num between", value1, value2, "aadBeforeNum");
            return (Criteria) this;
        }

        public Criteria andAadBeforeNumNotBetween(Double value1, Double value2) {
            addCriterion("aad_before_num not between", value1, value2, "aadBeforeNum");
            return (Criteria) this;
        }

        public Criteria andAadBeforeTrackCodeIsNull() {
            addCriterion("aad_before_track_code is null");
            return (Criteria) this;
        }

        public Criteria andAadBeforeTrackCodeIsNotNull() {
            addCriterion("aad_before_track_code is not null");
            return (Criteria) this;
        }

        public Criteria andAadBeforeTrackCodeEqualTo(String value) {
            addCriterion("aad_before_track_code =", value, "aadBeforeTrackCode");
            return (Criteria) this;
        }

        public Criteria andAadBeforeTrackCodeNotEqualTo(String value) {
            addCriterion("aad_before_track_code <>", value, "aadBeforeTrackCode");
            return (Criteria) this;
        }

        public Criteria andAadBeforeTrackCodeGreaterThan(String value) {
            addCriterion("aad_before_track_code >", value, "aadBeforeTrackCode");
            return (Criteria) this;
        }

        public Criteria andAadBeforeTrackCodeGreaterThanOrEqualTo(String value) {
            addCriterion("aad_before_track_code >=", value, "aadBeforeTrackCode");
            return (Criteria) this;
        }

        public Criteria andAadBeforeTrackCodeLessThan(String value) {
            addCriterion("aad_before_track_code <", value, "aadBeforeTrackCode");
            return (Criteria) this;
        }

        public Criteria andAadBeforeTrackCodeLessThanOrEqualTo(String value) {
            addCriterion("aad_before_track_code <=", value, "aadBeforeTrackCode");
            return (Criteria) this;
        }

        public Criteria andAadBeforeTrackCodeLike(String value) {
            addCriterion("aad_before_track_code like", value, "aadBeforeTrackCode");
            return (Criteria) this;
        }

        public Criteria andAadBeforeTrackCodeNotLike(String value) {
            addCriterion("aad_before_track_code not like", value, "aadBeforeTrackCode");
            return (Criteria) this;
        }

        public Criteria andAadBeforeTrackCodeIn(List<String> values) {
            addCriterion("aad_before_track_code in", values, "aadBeforeTrackCode");
            return (Criteria) this;
        }

        public Criteria andAadBeforeTrackCodeNotIn(List<String> values) {
            addCriterion("aad_before_track_code not in", values, "aadBeforeTrackCode");
            return (Criteria) this;
        }

        public Criteria andAadBeforeTrackCodeBetween(String value1, String value2) {
            addCriterion("aad_before_track_code between", value1, value2, "aadBeforeTrackCode");
            return (Criteria) this;
        }

        public Criteria andAadBeforeTrackCodeNotBetween(String value1, String value2) {
            addCriterion("aad_before_track_code not between", value1, value2, "aadBeforeTrackCode");
            return (Criteria) this;
        }

        public Criteria andAadBeforeUnitIsNull() {
            addCriterion("aad_before_unit is null");
            return (Criteria) this;
        }

        public Criteria andAadBeforeUnitIsNotNull() {
            addCriterion("aad_before_unit is not null");
            return (Criteria) this;
        }

        public Criteria andAadBeforeUnitEqualTo(String value) {
            addCriterion("aad_before_unit =", value, "aadBeforeUnit");
            return (Criteria) this;
        }

        public Criteria andAadBeforeUnitNotEqualTo(String value) {
            addCriterion("aad_before_unit <>", value, "aadBeforeUnit");
            return (Criteria) this;
        }

        public Criteria andAadBeforeUnitGreaterThan(String value) {
            addCriterion("aad_before_unit >", value, "aadBeforeUnit");
            return (Criteria) this;
        }

        public Criteria andAadBeforeUnitGreaterThanOrEqualTo(String value) {
            addCriterion("aad_before_unit >=", value, "aadBeforeUnit");
            return (Criteria) this;
        }

        public Criteria andAadBeforeUnitLessThan(String value) {
            addCriterion("aad_before_unit <", value, "aadBeforeUnit");
            return (Criteria) this;
        }

        public Criteria andAadBeforeUnitLessThanOrEqualTo(String value) {
            addCriterion("aad_before_unit <=", value, "aadBeforeUnit");
            return (Criteria) this;
        }

        public Criteria andAadBeforeUnitLike(String value) {
            addCriterion("aad_before_unit like", value, "aadBeforeUnit");
            return (Criteria) this;
        }

        public Criteria andAadBeforeUnitNotLike(String value) {
            addCriterion("aad_before_unit not like", value, "aadBeforeUnit");
            return (Criteria) this;
        }

        public Criteria andAadBeforeUnitIn(List<String> values) {
            addCriterion("aad_before_unit in", values, "aadBeforeUnit");
            return (Criteria) this;
        }

        public Criteria andAadBeforeUnitNotIn(List<String> values) {
            addCriterion("aad_before_unit not in", values, "aadBeforeUnit");
            return (Criteria) this;
        }

        public Criteria andAadBeforeUnitBetween(String value1, String value2) {
            addCriterion("aad_before_unit between", value1, value2, "aadBeforeUnit");
            return (Criteria) this;
        }

        public Criteria andAadBeforeUnitNotBetween(String value1, String value2) {
            addCriterion("aad_before_unit not between", value1, value2, "aadBeforeUnit");
            return (Criteria) this;
        }

        public Criteria andAadBeforePriceIsNull() {
            addCriterion("aad_before_price is null");
            return (Criteria) this;
        }

        public Criteria andAadBeforePriceIsNotNull() {
            addCriterion("aad_before_price is not null");
            return (Criteria) this;
        }

        public Criteria andAadBeforePriceEqualTo(Double value) {
            addCriterion("aad_before_price =", value, "aadBeforePrice");
            return (Criteria) this;
        }

        public Criteria andAadBeforePriceNotEqualTo(Double value) {
            addCriterion("aad_before_price <>", value, "aadBeforePrice");
            return (Criteria) this;
        }

        public Criteria andAadBeforePriceGreaterThan(Double value) {
            addCriterion("aad_before_price >", value, "aadBeforePrice");
            return (Criteria) this;
        }

        public Criteria andAadBeforePriceGreaterThanOrEqualTo(Double value) {
            addCriterion("aad_before_price >=", value, "aadBeforePrice");
            return (Criteria) this;
        }

        public Criteria andAadBeforePriceLessThan(Double value) {
            addCriterion("aad_before_price <", value, "aadBeforePrice");
            return (Criteria) this;
        }

        public Criteria andAadBeforePriceLessThanOrEqualTo(Double value) {
            addCriterion("aad_before_price <=", value, "aadBeforePrice");
            return (Criteria) this;
        }

        public Criteria andAadBeforePriceIn(List<Double> values) {
            addCriterion("aad_before_price in", values, "aadBeforePrice");
            return (Criteria) this;
        }

        public Criteria andAadBeforePriceNotIn(List<Double> values) {
            addCriterion("aad_before_price not in", values, "aadBeforePrice");
            return (Criteria) this;
        }

        public Criteria andAadBeforePriceBetween(Double value1, Double value2) {
            addCriterion("aad_before_price between", value1, value2, "aadBeforePrice");
            return (Criteria) this;
        }

        public Criteria andAadBeforePriceNotBetween(Double value1, Double value2) {
            addCriterion("aad_before_price not between", value1, value2, "aadBeforePrice");
            return (Criteria) this;
        }

        public Criteria andAadBeforeAmountIsNull() {
            addCriterion("aad_before_amount is null");
            return (Criteria) this;
        }

        public Criteria andAadBeforeAmountIsNotNull() {
            addCriterion("aad_before_amount is not null");
            return (Criteria) this;
        }

        public Criteria andAadBeforeAmountEqualTo(Double value) {
            addCriterion("aad_before_amount =", value, "aadBeforeAmount");
            return (Criteria) this;
        }

        public Criteria andAadBeforeAmountNotEqualTo(Double value) {
            addCriterion("aad_before_amount <>", value, "aadBeforeAmount");
            return (Criteria) this;
        }

        public Criteria andAadBeforeAmountGreaterThan(Double value) {
            addCriterion("aad_before_amount >", value, "aadBeforeAmount");
            return (Criteria) this;
        }

        public Criteria andAadBeforeAmountGreaterThanOrEqualTo(Double value) {
            addCriterion("aad_before_amount >=", value, "aadBeforeAmount");
            return (Criteria) this;
        }

        public Criteria andAadBeforeAmountLessThan(Double value) {
            addCriterion("aad_before_amount <", value, "aadBeforeAmount");
            return (Criteria) this;
        }

        public Criteria andAadBeforeAmountLessThanOrEqualTo(Double value) {
            addCriterion("aad_before_amount <=", value, "aadBeforeAmount");
            return (Criteria) this;
        }

        public Criteria andAadBeforeAmountIn(List<Double> values) {
            addCriterion("aad_before_amount in", values, "aadBeforeAmount");
            return (Criteria) this;
        }

        public Criteria andAadBeforeAmountNotIn(List<Double> values) {
            addCriterion("aad_before_amount not in", values, "aadBeforeAmount");
            return (Criteria) this;
        }

        public Criteria andAadBeforeAmountBetween(Double value1, Double value2) {
            addCriterion("aad_before_amount between", value1, value2, "aadBeforeAmount");
            return (Criteria) this;
        }

        public Criteria andAadBeforeAmountNotBetween(Double value1, Double value2) {
            addCriterion("aad_before_amount not between", value1, value2, "aadBeforeAmount");
            return (Criteria) this;
        }

        public Criteria andAadBeforePositionIsNull() {
            addCriterion("aad_before_position is null");
            return (Criteria) this;
        }

        public Criteria andAadBeforePositionIsNotNull() {
            addCriterion("aad_before_position is not null");
            return (Criteria) this;
        }

        public Criteria andAadBeforePositionEqualTo(String value) {
            addCriterion("aad_before_position =", value, "aadBeforePosition");
            return (Criteria) this;
        }

        public Criteria andAadBeforePositionNotEqualTo(String value) {
            addCriterion("aad_before_position <>", value, "aadBeforePosition");
            return (Criteria) this;
        }

        public Criteria andAadBeforePositionGreaterThan(String value) {
            addCriterion("aad_before_position >", value, "aadBeforePosition");
            return (Criteria) this;
        }

        public Criteria andAadBeforePositionGreaterThanOrEqualTo(String value) {
            addCriterion("aad_before_position >=", value, "aadBeforePosition");
            return (Criteria) this;
        }

        public Criteria andAadBeforePositionLessThan(String value) {
            addCriterion("aad_before_position <", value, "aadBeforePosition");
            return (Criteria) this;
        }

        public Criteria andAadBeforePositionLessThanOrEqualTo(String value) {
            addCriterion("aad_before_position <=", value, "aadBeforePosition");
            return (Criteria) this;
        }

        public Criteria andAadBeforePositionLike(String value) {
            addCriterion("aad_before_position like", value, "aadBeforePosition");
            return (Criteria) this;
        }

        public Criteria andAadBeforePositionNotLike(String value) {
            addCriterion("aad_before_position not like", value, "aadBeforePosition");
            return (Criteria) this;
        }

        public Criteria andAadBeforePositionIn(List<String> values) {
            addCriterion("aad_before_position in", values, "aadBeforePosition");
            return (Criteria) this;
        }

        public Criteria andAadBeforePositionNotIn(List<String> values) {
            addCriterion("aad_before_position not in", values, "aadBeforePosition");
            return (Criteria) this;
        }

        public Criteria andAadBeforePositionBetween(String value1, String value2) {
            addCriterion("aad_before_position between", value1, value2, "aadBeforePosition");
            return (Criteria) this;
        }

        public Criteria andAadBeforePositionNotBetween(String value1, String value2) {
            addCriterion("aad_before_position not between", value1, value2, "aadBeforePosition");
            return (Criteria) this;
        }

        public Criteria andAadBeforeIfFinishedProductIsNull() {
            addCriterion("aad_before_if_finished_product is null");
            return (Criteria) this;
        }

        public Criteria andAadBeforeIfFinishedProductIsNotNull() {
            addCriterion("aad_before_if_finished_product is not null");
            return (Criteria) this;
        }

        public Criteria andAadBeforeIfFinishedProductEqualTo(Integer value) {
            addCriterion("aad_before_if_finished_product =", value, "aadBeforeIfFinishedProduct");
            return (Criteria) this;
        }

        public Criteria andAadBeforeIfFinishedProductNotEqualTo(Integer value) {
            addCriterion("aad_before_if_finished_product <>", value, "aadBeforeIfFinishedProduct");
            return (Criteria) this;
        }

        public Criteria andAadBeforeIfFinishedProductGreaterThan(Integer value) {
            addCriterion("aad_before_if_finished_product >", value, "aadBeforeIfFinishedProduct");
            return (Criteria) this;
        }

        public Criteria andAadBeforeIfFinishedProductGreaterThanOrEqualTo(Integer value) {
            addCriterion("aad_before_if_finished_product >=", value, "aadBeforeIfFinishedProduct");
            return (Criteria) this;
        }

        public Criteria andAadBeforeIfFinishedProductLessThan(Integer value) {
            addCriterion("aad_before_if_finished_product <", value, "aadBeforeIfFinishedProduct");
            return (Criteria) this;
        }

        public Criteria andAadBeforeIfFinishedProductLessThanOrEqualTo(Integer value) {
            addCriterion("aad_before_if_finished_product <=", value, "aadBeforeIfFinishedProduct");
            return (Criteria) this;
        }

        public Criteria andAadBeforeIfFinishedProductIn(List<Integer> values) {
            addCriterion("aad_before_if_finished_product in", values, "aadBeforeIfFinishedProduct");
            return (Criteria) this;
        }

        public Criteria andAadBeforeIfFinishedProductNotIn(List<Integer> values) {
            addCriterion("aad_before_if_finished_product not in", values, "aadBeforeIfFinishedProduct");
            return (Criteria) this;
        }

        public Criteria andAadBeforeIfFinishedProductBetween(Integer value1, Integer value2) {
            addCriterion("aad_before_if_finished_product between", value1, value2, "aadBeforeIfFinishedProduct");
            return (Criteria) this;
        }

        public Criteria andAadBeforeIfFinishedProductNotBetween(Integer value1, Integer value2) {
            addCriterion("aad_before_if_finished_product not between", value1, value2, "aadBeforeIfFinishedProduct");
            return (Criteria) this;
        }

        public Criteria andAadBeforeRemarkIsNull() {
            addCriterion("aad_before_remark is null");
            return (Criteria) this;
        }

        public Criteria andAadBeforeRemarkIsNotNull() {
            addCriterion("aad_before_remark is not null");
            return (Criteria) this;
        }

        public Criteria andAadBeforeRemarkEqualTo(String value) {
            addCriterion("aad_before_remark =", value, "aadBeforeRemark");
            return (Criteria) this;
        }

        public Criteria andAadBeforeRemarkNotEqualTo(String value) {
            addCriterion("aad_before_remark <>", value, "aadBeforeRemark");
            return (Criteria) this;
        }

        public Criteria andAadBeforeRemarkGreaterThan(String value) {
            addCriterion("aad_before_remark >", value, "aadBeforeRemark");
            return (Criteria) this;
        }

        public Criteria andAadBeforeRemarkGreaterThanOrEqualTo(String value) {
            addCriterion("aad_before_remark >=", value, "aadBeforeRemark");
            return (Criteria) this;
        }

        public Criteria andAadBeforeRemarkLessThan(String value) {
            addCriterion("aad_before_remark <", value, "aadBeforeRemark");
            return (Criteria) this;
        }

        public Criteria andAadBeforeRemarkLessThanOrEqualTo(String value) {
            addCriterion("aad_before_remark <=", value, "aadBeforeRemark");
            return (Criteria) this;
        }

        public Criteria andAadBeforeRemarkLike(String value) {
            addCriterion("aad_before_remark like", value, "aadBeforeRemark");
            return (Criteria) this;
        }

        public Criteria andAadBeforeRemarkNotLike(String value) {
            addCriterion("aad_before_remark not like", value, "aadBeforeRemark");
            return (Criteria) this;
        }

        public Criteria andAadBeforeRemarkIn(List<String> values) {
            addCriterion("aad_before_remark in", values, "aadBeforeRemark");
            return (Criteria) this;
        }

        public Criteria andAadBeforeRemarkNotIn(List<String> values) {
            addCriterion("aad_before_remark not in", values, "aadBeforeRemark");
            return (Criteria) this;
        }

        public Criteria andAadBeforeRemarkBetween(String value1, String value2) {
            addCriterion("aad_before_remark between", value1, value2, "aadBeforeRemark");
            return (Criteria) this;
        }

        public Criteria andAadBeforeRemarkNotBetween(String value1, String value2) {
            addCriterion("aad_before_remark not between", value1, value2, "aadBeforeRemark");
            return (Criteria) this;
        }

        public Criteria andAadBeforeMatTypeIsNull() {
            addCriterion("aad_before_mat_type is null");
            return (Criteria) this;
        }

        public Criteria andAadBeforeMatTypeIsNotNull() {
            addCriterion("aad_before_mat_type is not null");
            return (Criteria) this;
        }

        public Criteria andAadBeforeMatTypeEqualTo(Integer value) {
            addCriterion("aad_before_mat_type =", value, "aadBeforeMatType");
            return (Criteria) this;
        }

        public Criteria andAadBeforeMatTypeNotEqualTo(Integer value) {
            addCriterion("aad_before_mat_type <>", value, "aadBeforeMatType");
            return (Criteria) this;
        }

        public Criteria andAadBeforeMatTypeGreaterThan(Integer value) {
            addCriterion("aad_before_mat_type >", value, "aadBeforeMatType");
            return (Criteria) this;
        }

        public Criteria andAadBeforeMatTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("aad_before_mat_type >=", value, "aadBeforeMatType");
            return (Criteria) this;
        }

        public Criteria andAadBeforeMatTypeLessThan(Integer value) {
            addCriterion("aad_before_mat_type <", value, "aadBeforeMatType");
            return (Criteria) this;
        }

        public Criteria andAadBeforeMatTypeLessThanOrEqualTo(Integer value) {
            addCriterion("aad_before_mat_type <=", value, "aadBeforeMatType");
            return (Criteria) this;
        }

        public Criteria andAadBeforeMatTypeIn(List<Integer> values) {
            addCriterion("aad_before_mat_type in", values, "aadBeforeMatType");
            return (Criteria) this;
        }

        public Criteria andAadBeforeMatTypeNotIn(List<Integer> values) {
            addCriterion("aad_before_mat_type not in", values, "aadBeforeMatType");
            return (Criteria) this;
        }

        public Criteria andAadBeforeMatTypeBetween(Integer value1, Integer value2) {
            addCriterion("aad_before_mat_type between", value1, value2, "aadBeforeMatType");
            return (Criteria) this;
        }

        public Criteria andAadBeforeMatTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("aad_before_mat_type not between", value1, value2, "aadBeforeMatType");
            return (Criteria) this;
        }

        public Criteria andAadBeforeCaseNoIsNull() {
            addCriterion("aad_before_case_no is null");
            return (Criteria) this;
        }

        public Criteria andAadBeforeCaseNoIsNotNull() {
            addCriterion("aad_before_case_no is not null");
            return (Criteria) this;
        }

        public Criteria andAadBeforeCaseNoEqualTo(String value) {
            addCriterion("aad_before_case_no =", value, "aadBeforeCaseNo");
            return (Criteria) this;
        }

        public Criteria andAadBeforeCaseNoNotEqualTo(String value) {
            addCriterion("aad_before_case_no <>", value, "aadBeforeCaseNo");
            return (Criteria) this;
        }

        public Criteria andAadBeforeCaseNoGreaterThan(String value) {
            addCriterion("aad_before_case_no >", value, "aadBeforeCaseNo");
            return (Criteria) this;
        }

        public Criteria andAadBeforeCaseNoGreaterThanOrEqualTo(String value) {
            addCriterion("aad_before_case_no >=", value, "aadBeforeCaseNo");
            return (Criteria) this;
        }

        public Criteria andAadBeforeCaseNoLessThan(String value) {
            addCriterion("aad_before_case_no <", value, "aadBeforeCaseNo");
            return (Criteria) this;
        }

        public Criteria andAadBeforeCaseNoLessThanOrEqualTo(String value) {
            addCriterion("aad_before_case_no <=", value, "aadBeforeCaseNo");
            return (Criteria) this;
        }

        public Criteria andAadBeforeCaseNoLike(String value) {
            addCriterion("aad_before_case_no like", value, "aadBeforeCaseNo");
            return (Criteria) this;
        }

        public Criteria andAadBeforeCaseNoNotLike(String value) {
            addCriterion("aad_before_case_no not like", value, "aadBeforeCaseNo");
            return (Criteria) this;
        }

        public Criteria andAadBeforeCaseNoIn(List<String> values) {
            addCriterion("aad_before_case_no in", values, "aadBeforeCaseNo");
            return (Criteria) this;
        }

        public Criteria andAadBeforeCaseNoNotIn(List<String> values) {
            addCriterion("aad_before_case_no not in", values, "aadBeforeCaseNo");
            return (Criteria) this;
        }

        public Criteria andAadBeforeCaseNoBetween(String value1, String value2) {
            addCriterion("aad_before_case_no between", value1, value2, "aadBeforeCaseNo");
            return (Criteria) this;
        }

        public Criteria andAadBeforeCaseNoNotBetween(String value1, String value2) {
            addCriterion("aad_before_case_no not between", value1, value2, "aadBeforeCaseNo");
            return (Criteria) this;
        }

        public Criteria andAadBeforeBoxingDateIsNull() {
            addCriterion("aad_before_boxing_date is null");
            return (Criteria) this;
        }

        public Criteria andAadBeforeBoxingDateIsNotNull() {
            addCriterion("aad_before_boxing_date is not null");
            return (Criteria) this;
        }

        public Criteria andAadBeforeBoxingDateEqualTo(Date value) {
            addCriterion("aad_before_boxing_date =", value, "aadBeforeBoxingDate");
            return (Criteria) this;
        }

        public Criteria andAadBeforeBoxingDateNotEqualTo(Date value) {
            addCriterion("aad_before_boxing_date <>", value, "aadBeforeBoxingDate");
            return (Criteria) this;
        }

        public Criteria andAadBeforeBoxingDateGreaterThan(Date value) {
            addCriterion("aad_before_boxing_date >", value, "aadBeforeBoxingDate");
            return (Criteria) this;
        }

        public Criteria andAadBeforeBoxingDateGreaterThanOrEqualTo(Date value) {
            addCriterion("aad_before_boxing_date >=", value, "aadBeforeBoxingDate");
            return (Criteria) this;
        }

        public Criteria andAadBeforeBoxingDateLessThan(Date value) {
            addCriterion("aad_before_boxing_date <", value, "aadBeforeBoxingDate");
            return (Criteria) this;
        }

        public Criteria andAadBeforeBoxingDateLessThanOrEqualTo(Date value) {
            addCriterion("aad_before_boxing_date <=", value, "aadBeforeBoxingDate");
            return (Criteria) this;
        }

        public Criteria andAadBeforeBoxingDateIn(List<Date> values) {
            addCriterion("aad_before_boxing_date in", values, "aadBeforeBoxingDate");
            return (Criteria) this;
        }

        public Criteria andAadBeforeBoxingDateNotIn(List<Date> values) {
            addCriterion("aad_before_boxing_date not in", values, "aadBeforeBoxingDate");
            return (Criteria) this;
        }

        public Criteria andAadBeforeBoxingDateBetween(Date value1, Date value2) {
            addCriterion("aad_before_boxing_date between", value1, value2, "aadBeforeBoxingDate");
            return (Criteria) this;
        }

        public Criteria andAadBeforeBoxingDateNotBetween(Date value1, Date value2) {
            addCriterion("aad_before_boxing_date not between", value1, value2, "aadBeforeBoxingDate");
            return (Criteria) this;
        }

        public Criteria andAadBeforeStockTypeIsNull() {
            addCriterion("aad_before_stock_type is null");
            return (Criteria) this;
        }

        public Criteria andAadBeforeStockTypeIsNotNull() {
            addCriterion("aad_before_stock_type is not null");
            return (Criteria) this;
        }

        public Criteria andAadBeforeStockTypeEqualTo(Integer value) {
            addCriterion("aad_before_stock_type =", value, "aadBeforeStockType");
            return (Criteria) this;
        }

        public Criteria andAadBeforeStockTypeNotEqualTo(Integer value) {
            addCriterion("aad_before_stock_type <>", value, "aadBeforeStockType");
            return (Criteria) this;
        }

        public Criteria andAadBeforeStockTypeGreaterThan(Integer value) {
            addCriterion("aad_before_stock_type >", value, "aadBeforeStockType");
            return (Criteria) this;
        }

        public Criteria andAadBeforeStockTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("aad_before_stock_type >=", value, "aadBeforeStockType");
            return (Criteria) this;
        }

        public Criteria andAadBeforeStockTypeLessThan(Integer value) {
            addCriterion("aad_before_stock_type <", value, "aadBeforeStockType");
            return (Criteria) this;
        }

        public Criteria andAadBeforeStockTypeLessThanOrEqualTo(Integer value) {
            addCriterion("aad_before_stock_type <=", value, "aadBeforeStockType");
            return (Criteria) this;
        }

        public Criteria andAadBeforeStockTypeIn(List<Integer> values) {
            addCriterion("aad_before_stock_type in", values, "aadBeforeStockType");
            return (Criteria) this;
        }

        public Criteria andAadBeforeStockTypeNotIn(List<Integer> values) {
            addCriterion("aad_before_stock_type not in", values, "aadBeforeStockType");
            return (Criteria) this;
        }

        public Criteria andAadBeforeStockTypeBetween(Integer value1, Integer value2) {
            addCriterion("aad_before_stock_type between", value1, value2, "aadBeforeStockType");
            return (Criteria) this;
        }

        public Criteria andAadBeforeStockTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("aad_before_stock_type not between", value1, value2, "aadBeforeStockType");
            return (Criteria) this;
        }

        public Criteria andAadAfterMatCodeIsNull() {
            addCriterion("aad_after_mat_code is null");
            return (Criteria) this;
        }

        public Criteria andAadAfterMatCodeIsNotNull() {
            addCriterion("aad_after_mat_code is not null");
            return (Criteria) this;
        }

        public Criteria andAadAfterMatCodeEqualTo(String value) {
            addCriterion("aad_after_mat_code =", value, "aadAfterMatCode");
            return (Criteria) this;
        }

        public Criteria andAadAfterMatCodeNotEqualTo(String value) {
            addCriterion("aad_after_mat_code <>", value, "aadAfterMatCode");
            return (Criteria) this;
        }

        public Criteria andAadAfterMatCodeGreaterThan(String value) {
            addCriterion("aad_after_mat_code >", value, "aadAfterMatCode");
            return (Criteria) this;
        }

        public Criteria andAadAfterMatCodeGreaterThanOrEqualTo(String value) {
            addCriterion("aad_after_mat_code >=", value, "aadAfterMatCode");
            return (Criteria) this;
        }

        public Criteria andAadAfterMatCodeLessThan(String value) {
            addCriterion("aad_after_mat_code <", value, "aadAfterMatCode");
            return (Criteria) this;
        }

        public Criteria andAadAfterMatCodeLessThanOrEqualTo(String value) {
            addCriterion("aad_after_mat_code <=", value, "aadAfterMatCode");
            return (Criteria) this;
        }

        public Criteria andAadAfterMatCodeLike(String value) {
            addCriterion("aad_after_mat_code like", value, "aadAfterMatCode");
            return (Criteria) this;
        }

        public Criteria andAadAfterMatCodeNotLike(String value) {
            addCriterion("aad_after_mat_code not like", value, "aadAfterMatCode");
            return (Criteria) this;
        }

        public Criteria andAadAfterMatCodeIn(List<String> values) {
            addCriterion("aad_after_mat_code in", values, "aadAfterMatCode");
            return (Criteria) this;
        }

        public Criteria andAadAfterMatCodeNotIn(List<String> values) {
            addCriterion("aad_after_mat_code not in", values, "aadAfterMatCode");
            return (Criteria) this;
        }

        public Criteria andAadAfterMatCodeBetween(String value1, String value2) {
            addCriterion("aad_after_mat_code between", value1, value2, "aadAfterMatCode");
            return (Criteria) this;
        }

        public Criteria andAadAfterMatCodeNotBetween(String value1, String value2) {
            addCriterion("aad_after_mat_code not between", value1, value2, "aadAfterMatCode");
            return (Criteria) this;
        }

        public Criteria andAadAfterMatNameIsNull() {
            addCriterion("aad_after_mat_name is null");
            return (Criteria) this;
        }

        public Criteria andAadAfterMatNameIsNotNull() {
            addCriterion("aad_after_mat_name is not null");
            return (Criteria) this;
        }

        public Criteria andAadAfterMatNameEqualTo(String value) {
            addCriterion("aad_after_mat_name =", value, "aadAfterMatName");
            return (Criteria) this;
        }

        public Criteria andAadAfterMatNameNotEqualTo(String value) {
            addCriterion("aad_after_mat_name <>", value, "aadAfterMatName");
            return (Criteria) this;
        }

        public Criteria andAadAfterMatNameGreaterThan(String value) {
            addCriterion("aad_after_mat_name >", value, "aadAfterMatName");
            return (Criteria) this;
        }

        public Criteria andAadAfterMatNameGreaterThanOrEqualTo(String value) {
            addCriterion("aad_after_mat_name >=", value, "aadAfterMatName");
            return (Criteria) this;
        }

        public Criteria andAadAfterMatNameLessThan(String value) {
            addCriterion("aad_after_mat_name <", value, "aadAfterMatName");
            return (Criteria) this;
        }

        public Criteria andAadAfterMatNameLessThanOrEqualTo(String value) {
            addCriterion("aad_after_mat_name <=", value, "aadAfterMatName");
            return (Criteria) this;
        }

        public Criteria andAadAfterMatNameLike(String value) {
            addCriterion("aad_after_mat_name like", value, "aadAfterMatName");
            return (Criteria) this;
        }

        public Criteria andAadAfterMatNameNotLike(String value) {
            addCriterion("aad_after_mat_name not like", value, "aadAfterMatName");
            return (Criteria) this;
        }

        public Criteria andAadAfterMatNameIn(List<String> values) {
            addCriterion("aad_after_mat_name in", values, "aadAfterMatName");
            return (Criteria) this;
        }

        public Criteria andAadAfterMatNameNotIn(List<String> values) {
            addCriterion("aad_after_mat_name not in", values, "aadAfterMatName");
            return (Criteria) this;
        }

        public Criteria andAadAfterMatNameBetween(String value1, String value2) {
            addCriterion("aad_after_mat_name between", value1, value2, "aadAfterMatName");
            return (Criteria) this;
        }

        public Criteria andAadAfterMatNameNotBetween(String value1, String value2) {
            addCriterion("aad_after_mat_name not between", value1, value2, "aadAfterMatName");
            return (Criteria) this;
        }

        public Criteria andAadAfterProjectCodeIsNull() {
            addCriterion("aad_after_project_code is null");
            return (Criteria) this;
        }

        public Criteria andAadAfterProjectCodeIsNotNull() {
            addCriterion("aad_after_project_code is not null");
            return (Criteria) this;
        }

        public Criteria andAadAfterProjectCodeEqualTo(String value) {
            addCriterion("aad_after_project_code =", value, "aadAfterProjectCode");
            return (Criteria) this;
        }

        public Criteria andAadAfterProjectCodeNotEqualTo(String value) {
            addCriterion("aad_after_project_code <>", value, "aadAfterProjectCode");
            return (Criteria) this;
        }

        public Criteria andAadAfterProjectCodeGreaterThan(String value) {
            addCriterion("aad_after_project_code >", value, "aadAfterProjectCode");
            return (Criteria) this;
        }

        public Criteria andAadAfterProjectCodeGreaterThanOrEqualTo(String value) {
            addCriterion("aad_after_project_code >=", value, "aadAfterProjectCode");
            return (Criteria) this;
        }

        public Criteria andAadAfterProjectCodeLessThan(String value) {
            addCriterion("aad_after_project_code <", value, "aadAfterProjectCode");
            return (Criteria) this;
        }

        public Criteria andAadAfterProjectCodeLessThanOrEqualTo(String value) {
            addCriterion("aad_after_project_code <=", value, "aadAfterProjectCode");
            return (Criteria) this;
        }

        public Criteria andAadAfterProjectCodeLike(String value) {
            addCriterion("aad_after_project_code like", value, "aadAfterProjectCode");
            return (Criteria) this;
        }

        public Criteria andAadAfterProjectCodeNotLike(String value) {
            addCriterion("aad_after_project_code not like", value, "aadAfterProjectCode");
            return (Criteria) this;
        }

        public Criteria andAadAfterProjectCodeIn(List<String> values) {
            addCriterion("aad_after_project_code in", values, "aadAfterProjectCode");
            return (Criteria) this;
        }

        public Criteria andAadAfterProjectCodeNotIn(List<String> values) {
            addCriterion("aad_after_project_code not in", values, "aadAfterProjectCode");
            return (Criteria) this;
        }

        public Criteria andAadAfterProjectCodeBetween(String value1, String value2) {
            addCriterion("aad_after_project_code between", value1, value2, "aadAfterProjectCode");
            return (Criteria) this;
        }

        public Criteria andAadAfterProjectCodeNotBetween(String value1, String value2) {
            addCriterion("aad_after_project_code not between", value1, value2, "aadAfterProjectCode");
            return (Criteria) this;
        }

        public Criteria andAadAfterProjectNameIsNull() {
            addCriterion("aad_after_project_name is null");
            return (Criteria) this;
        }

        public Criteria andAadAfterProjectNameIsNotNull() {
            addCriterion("aad_after_project_name is not null");
            return (Criteria) this;
        }

        public Criteria andAadAfterProjectNameEqualTo(String value) {
            addCriterion("aad_after_project_name =", value, "aadAfterProjectName");
            return (Criteria) this;
        }

        public Criteria andAadAfterProjectNameNotEqualTo(String value) {
            addCriterion("aad_after_project_name <>", value, "aadAfterProjectName");
            return (Criteria) this;
        }

        public Criteria andAadAfterProjectNameGreaterThan(String value) {
            addCriterion("aad_after_project_name >", value, "aadAfterProjectName");
            return (Criteria) this;
        }

        public Criteria andAadAfterProjectNameGreaterThanOrEqualTo(String value) {
            addCriterion("aad_after_project_name >=", value, "aadAfterProjectName");
            return (Criteria) this;
        }

        public Criteria andAadAfterProjectNameLessThan(String value) {
            addCriterion("aad_after_project_name <", value, "aadAfterProjectName");
            return (Criteria) this;
        }

        public Criteria andAadAfterProjectNameLessThanOrEqualTo(String value) {
            addCriterion("aad_after_project_name <=", value, "aadAfterProjectName");
            return (Criteria) this;
        }

        public Criteria andAadAfterProjectNameLike(String value) {
            addCriterion("aad_after_project_name like", value, "aadAfterProjectName");
            return (Criteria) this;
        }

        public Criteria andAadAfterProjectNameNotLike(String value) {
            addCriterion("aad_after_project_name not like", value, "aadAfterProjectName");
            return (Criteria) this;
        }

        public Criteria andAadAfterProjectNameIn(List<String> values) {
            addCriterion("aad_after_project_name in", values, "aadAfterProjectName");
            return (Criteria) this;
        }

        public Criteria andAadAfterProjectNameNotIn(List<String> values) {
            addCriterion("aad_after_project_name not in", values, "aadAfterProjectName");
            return (Criteria) this;
        }

        public Criteria andAadAfterProjectNameBetween(String value1, String value2) {
            addCriterion("aad_after_project_name between", value1, value2, "aadAfterProjectName");
            return (Criteria) this;
        }

        public Criteria andAadAfterProjectNameNotBetween(String value1, String value2) {
            addCriterion("aad_after_project_name not between", value1, value2, "aadAfterProjectName");
            return (Criteria) this;
        }

        public Criteria andAadAfterPartIsNull() {
            addCriterion("aad_after_part is null");
            return (Criteria) this;
        }

        public Criteria andAadAfterPartIsNotNull() {
            addCriterion("aad_after_part is not null");
            return (Criteria) this;
        }

        public Criteria andAadAfterPartEqualTo(String value) {
            addCriterion("aad_after_part =", value, "aadAfterPart");
            return (Criteria) this;
        }

        public Criteria andAadAfterPartNotEqualTo(String value) {
            addCriterion("aad_after_part <>", value, "aadAfterPart");
            return (Criteria) this;
        }

        public Criteria andAadAfterPartGreaterThan(String value) {
            addCriterion("aad_after_part >", value, "aadAfterPart");
            return (Criteria) this;
        }

        public Criteria andAadAfterPartGreaterThanOrEqualTo(String value) {
            addCriterion("aad_after_part >=", value, "aadAfterPart");
            return (Criteria) this;
        }

        public Criteria andAadAfterPartLessThan(String value) {
            addCriterion("aad_after_part <", value, "aadAfterPart");
            return (Criteria) this;
        }

        public Criteria andAadAfterPartLessThanOrEqualTo(String value) {
            addCriterion("aad_after_part <=", value, "aadAfterPart");
            return (Criteria) this;
        }

        public Criteria andAadAfterPartLike(String value) {
            addCriterion("aad_after_part like", value, "aadAfterPart");
            return (Criteria) this;
        }

        public Criteria andAadAfterPartNotLike(String value) {
            addCriterion("aad_after_part not like", value, "aadAfterPart");
            return (Criteria) this;
        }

        public Criteria andAadAfterPartIn(List<String> values) {
            addCriterion("aad_after_part in", values, "aadAfterPart");
            return (Criteria) this;
        }

        public Criteria andAadAfterPartNotIn(List<String> values) {
            addCriterion("aad_after_part not in", values, "aadAfterPart");
            return (Criteria) this;
        }

        public Criteria andAadAfterPartBetween(String value1, String value2) {
            addCriterion("aad_after_part between", value1, value2, "aadAfterPart");
            return (Criteria) this;
        }

        public Criteria andAadAfterPartNotBetween(String value1, String value2) {
            addCriterion("aad_after_part not between", value1, value2, "aadAfterPart");
            return (Criteria) this;
        }

        public Criteria andAadAfterDrawingNoIsNull() {
            addCriterion("aad_after_drawing_no is null");
            return (Criteria) this;
        }

        public Criteria andAadAfterDrawingNoIsNotNull() {
            addCriterion("aad_after_drawing_no is not null");
            return (Criteria) this;
        }

        public Criteria andAadAfterDrawingNoEqualTo(String value) {
            addCriterion("aad_after_drawing_no =", value, "aadAfterDrawingNo");
            return (Criteria) this;
        }

        public Criteria andAadAfterDrawingNoNotEqualTo(String value) {
            addCriterion("aad_after_drawing_no <>", value, "aadAfterDrawingNo");
            return (Criteria) this;
        }

        public Criteria andAadAfterDrawingNoGreaterThan(String value) {
            addCriterion("aad_after_drawing_no >", value, "aadAfterDrawingNo");
            return (Criteria) this;
        }

        public Criteria andAadAfterDrawingNoGreaterThanOrEqualTo(String value) {
            addCriterion("aad_after_drawing_no >=", value, "aadAfterDrawingNo");
            return (Criteria) this;
        }

        public Criteria andAadAfterDrawingNoLessThan(String value) {
            addCriterion("aad_after_drawing_no <", value, "aadAfterDrawingNo");
            return (Criteria) this;
        }

        public Criteria andAadAfterDrawingNoLessThanOrEqualTo(String value) {
            addCriterion("aad_after_drawing_no <=", value, "aadAfterDrawingNo");
            return (Criteria) this;
        }

        public Criteria andAadAfterDrawingNoLike(String value) {
            addCriterion("aad_after_drawing_no like", value, "aadAfterDrawingNo");
            return (Criteria) this;
        }

        public Criteria andAadAfterDrawingNoNotLike(String value) {
            addCriterion("aad_after_drawing_no not like", value, "aadAfterDrawingNo");
            return (Criteria) this;
        }

        public Criteria andAadAfterDrawingNoIn(List<String> values) {
            addCriterion("aad_after_drawing_no in", values, "aadAfterDrawingNo");
            return (Criteria) this;
        }

        public Criteria andAadAfterDrawingNoNotIn(List<String> values) {
            addCriterion("aad_after_drawing_no not in", values, "aadAfterDrawingNo");
            return (Criteria) this;
        }

        public Criteria andAadAfterDrawingNoBetween(String value1, String value2) {
            addCriterion("aad_after_drawing_no between", value1, value2, "aadAfterDrawingNo");
            return (Criteria) this;
        }

        public Criteria andAadAfterDrawingNoNotBetween(String value1, String value2) {
            addCriterion("aad_after_drawing_no not between", value1, value2, "aadAfterDrawingNo");
            return (Criteria) this;
        }

        public Criteria andAadAfterMakingPiecesStatusIsNull() {
            addCriterion("aad_after_making_pieces_status is null");
            return (Criteria) this;
        }

        public Criteria andAadAfterMakingPiecesStatusIsNotNull() {
            addCriterion("aad_after_making_pieces_status is not null");
            return (Criteria) this;
        }

        public Criteria andAadAfterMakingPiecesStatusEqualTo(String value) {
            addCriterion("aad_after_making_pieces_status =", value, "aadAfterMakingPiecesStatus");
            return (Criteria) this;
        }

        public Criteria andAadAfterMakingPiecesStatusNotEqualTo(String value) {
            addCriterion("aad_after_making_pieces_status <>", value, "aadAfterMakingPiecesStatus");
            return (Criteria) this;
        }

        public Criteria andAadAfterMakingPiecesStatusGreaterThan(String value) {
            addCriterion("aad_after_making_pieces_status >", value, "aadAfterMakingPiecesStatus");
            return (Criteria) this;
        }

        public Criteria andAadAfterMakingPiecesStatusGreaterThanOrEqualTo(String value) {
            addCriterion("aad_after_making_pieces_status >=", value, "aadAfterMakingPiecesStatus");
            return (Criteria) this;
        }

        public Criteria andAadAfterMakingPiecesStatusLessThan(String value) {
            addCriterion("aad_after_making_pieces_status <", value, "aadAfterMakingPiecesStatus");
            return (Criteria) this;
        }

        public Criteria andAadAfterMakingPiecesStatusLessThanOrEqualTo(String value) {
            addCriterion("aad_after_making_pieces_status <=", value, "aadAfterMakingPiecesStatus");
            return (Criteria) this;
        }

        public Criteria andAadAfterMakingPiecesStatusLike(String value) {
            addCriterion("aad_after_making_pieces_status like", value, "aadAfterMakingPiecesStatus");
            return (Criteria) this;
        }

        public Criteria andAadAfterMakingPiecesStatusNotLike(String value) {
            addCriterion("aad_after_making_pieces_status not like", value, "aadAfterMakingPiecesStatus");
            return (Criteria) this;
        }

        public Criteria andAadAfterMakingPiecesStatusIn(List<String> values) {
            addCriterion("aad_after_making_pieces_status in", values, "aadAfterMakingPiecesStatus");
            return (Criteria) this;
        }

        public Criteria andAadAfterMakingPiecesStatusNotIn(List<String> values) {
            addCriterion("aad_after_making_pieces_status not in", values, "aadAfterMakingPiecesStatus");
            return (Criteria) this;
        }

        public Criteria andAadAfterMakingPiecesStatusBetween(String value1, String value2) {
            addCriterion("aad_after_making_pieces_status between", value1, value2, "aadAfterMakingPiecesStatus");
            return (Criteria) this;
        }

        public Criteria andAadAfterMakingPiecesStatusNotBetween(String value1, String value2) {
            addCriterion("aad_after_making_pieces_status not between", value1, value2, "aadAfterMakingPiecesStatus");
            return (Criteria) this;
        }

        public Criteria andAadAfterBrandIsNull() {
            addCriterion("aad_after_brand is null");
            return (Criteria) this;
        }

        public Criteria andAadAfterBrandIsNotNull() {
            addCriterion("aad_after_brand is not null");
            return (Criteria) this;
        }

        public Criteria andAadAfterBrandEqualTo(String value) {
            addCriterion("aad_after_brand =", value, "aadAfterBrand");
            return (Criteria) this;
        }

        public Criteria andAadAfterBrandNotEqualTo(String value) {
            addCriterion("aad_after_brand <>", value, "aadAfterBrand");
            return (Criteria) this;
        }

        public Criteria andAadAfterBrandGreaterThan(String value) {
            addCriterion("aad_after_brand >", value, "aadAfterBrand");
            return (Criteria) this;
        }

        public Criteria andAadAfterBrandGreaterThanOrEqualTo(String value) {
            addCriterion("aad_after_brand >=", value, "aadAfterBrand");
            return (Criteria) this;
        }

        public Criteria andAadAfterBrandLessThan(String value) {
            addCriterion("aad_after_brand <", value, "aadAfterBrand");
            return (Criteria) this;
        }

        public Criteria andAadAfterBrandLessThanOrEqualTo(String value) {
            addCriterion("aad_after_brand <=", value, "aadAfterBrand");
            return (Criteria) this;
        }

        public Criteria andAadAfterBrandLike(String value) {
            addCriterion("aad_after_brand like", value, "aadAfterBrand");
            return (Criteria) this;
        }

        public Criteria andAadAfterBrandNotLike(String value) {
            addCriterion("aad_after_brand not like", value, "aadAfterBrand");
            return (Criteria) this;
        }

        public Criteria andAadAfterBrandIn(List<String> values) {
            addCriterion("aad_after_brand in", values, "aadAfterBrand");
            return (Criteria) this;
        }

        public Criteria andAadAfterBrandNotIn(List<String> values) {
            addCriterion("aad_after_brand not in", values, "aadAfterBrand");
            return (Criteria) this;
        }

        public Criteria andAadAfterBrandBetween(String value1, String value2) {
            addCriterion("aad_after_brand between", value1, value2, "aadAfterBrand");
            return (Criteria) this;
        }

        public Criteria andAadAfterBrandNotBetween(String value1, String value2) {
            addCriterion("aad_after_brand not between", value1, value2, "aadAfterBrand");
            return (Criteria) this;
        }

        public Criteria andAadAfterSapMatCodeIsNull() {
            addCriterion("aad_after_sap_mat_code is null");
            return (Criteria) this;
        }

        public Criteria andAadAfterSapMatCodeIsNotNull() {
            addCriterion("aad_after_sap_mat_code is not null");
            return (Criteria) this;
        }

        public Criteria andAadAfterSapMatCodeEqualTo(String value) {
            addCriterion("aad_after_sap_mat_code =", value, "aadAfterSapMatCode");
            return (Criteria) this;
        }

        public Criteria andAadAfterSapMatCodeNotEqualTo(String value) {
            addCriterion("aad_after_sap_mat_code <>", value, "aadAfterSapMatCode");
            return (Criteria) this;
        }

        public Criteria andAadAfterSapMatCodeGreaterThan(String value) {
            addCriterion("aad_after_sap_mat_code >", value, "aadAfterSapMatCode");
            return (Criteria) this;
        }

        public Criteria andAadAfterSapMatCodeGreaterThanOrEqualTo(String value) {
            addCriterion("aad_after_sap_mat_code >=", value, "aadAfterSapMatCode");
            return (Criteria) this;
        }

        public Criteria andAadAfterSapMatCodeLessThan(String value) {
            addCriterion("aad_after_sap_mat_code <", value, "aadAfterSapMatCode");
            return (Criteria) this;
        }

        public Criteria andAadAfterSapMatCodeLessThanOrEqualTo(String value) {
            addCriterion("aad_after_sap_mat_code <=", value, "aadAfterSapMatCode");
            return (Criteria) this;
        }

        public Criteria andAadAfterSapMatCodeLike(String value) {
            addCriterion("aad_after_sap_mat_code like", value, "aadAfterSapMatCode");
            return (Criteria) this;
        }

        public Criteria andAadAfterSapMatCodeNotLike(String value) {
            addCriterion("aad_after_sap_mat_code not like", value, "aadAfterSapMatCode");
            return (Criteria) this;
        }

        public Criteria andAadAfterSapMatCodeIn(List<String> values) {
            addCriterion("aad_after_sap_mat_code in", values, "aadAfterSapMatCode");
            return (Criteria) this;
        }

        public Criteria andAadAfterSapMatCodeNotIn(List<String> values) {
            addCriterion("aad_after_sap_mat_code not in", values, "aadAfterSapMatCode");
            return (Criteria) this;
        }

        public Criteria andAadAfterSapMatCodeBetween(String value1, String value2) {
            addCriterion("aad_after_sap_mat_code between", value1, value2, "aadAfterSapMatCode");
            return (Criteria) this;
        }

        public Criteria andAadAfterSapMatCodeNotBetween(String value1, String value2) {
            addCriterion("aad_after_sap_mat_code not between", value1, value2, "aadAfterSapMatCode");
            return (Criteria) this;
        }

        public Criteria andAadAfterNumIsNull() {
            addCriterion("aad_after_num is null");
            return (Criteria) this;
        }

        public Criteria andAadAfterNumIsNotNull() {
            addCriterion("aad_after_num is not null");
            return (Criteria) this;
        }

        public Criteria andAadAfterNumEqualTo(Double value) {
            addCriterion("aad_after_num =", value, "aadAfterNum");
            return (Criteria) this;
        }

        public Criteria andAadAfterNumNotEqualTo(Double value) {
            addCriterion("aad_after_num <>", value, "aadAfterNum");
            return (Criteria) this;
        }

        public Criteria andAadAfterNumGreaterThan(Double value) {
            addCriterion("aad_after_num >", value, "aadAfterNum");
            return (Criteria) this;
        }

        public Criteria andAadAfterNumGreaterThanOrEqualTo(Double value) {
            addCriterion("aad_after_num >=", value, "aadAfterNum");
            return (Criteria) this;
        }

        public Criteria andAadAfterNumLessThan(Double value) {
            addCriterion("aad_after_num <", value, "aadAfterNum");
            return (Criteria) this;
        }

        public Criteria andAadAfterNumLessThanOrEqualTo(Double value) {
            addCriterion("aad_after_num <=", value, "aadAfterNum");
            return (Criteria) this;
        }

        public Criteria andAadAfterNumIn(List<Double> values) {
            addCriterion("aad_after_num in", values, "aadAfterNum");
            return (Criteria) this;
        }

        public Criteria andAadAfterNumNotIn(List<Double> values) {
            addCriterion("aad_after_num not in", values, "aadAfterNum");
            return (Criteria) this;
        }

        public Criteria andAadAfterNumBetween(Double value1, Double value2) {
            addCriterion("aad_after_num between", value1, value2, "aadAfterNum");
            return (Criteria) this;
        }

        public Criteria andAadAfterNumNotBetween(Double value1, Double value2) {
            addCriterion("aad_after_num not between", value1, value2, "aadAfterNum");
            return (Criteria) this;
        }

        public Criteria andAadAfterTrackCodeIsNull() {
            addCriterion("aad_after_track_code is null");
            return (Criteria) this;
        }

        public Criteria andAadAfterTrackCodeIsNotNull() {
            addCriterion("aad_after_track_code is not null");
            return (Criteria) this;
        }

        public Criteria andAadAfterTrackCodeEqualTo(String value) {
            addCriterion("aad_after_track_code =", value, "aadAfterTrackCode");
            return (Criteria) this;
        }

        public Criteria andAadAfterTrackCodeNotEqualTo(String value) {
            addCriterion("aad_after_track_code <>", value, "aadAfterTrackCode");
            return (Criteria) this;
        }

        public Criteria andAadAfterTrackCodeGreaterThan(String value) {
            addCriterion("aad_after_track_code >", value, "aadAfterTrackCode");
            return (Criteria) this;
        }

        public Criteria andAadAfterTrackCodeGreaterThanOrEqualTo(String value) {
            addCriterion("aad_after_track_code >=", value, "aadAfterTrackCode");
            return (Criteria) this;
        }

        public Criteria andAadAfterTrackCodeLessThan(String value) {
            addCriterion("aad_after_track_code <", value, "aadAfterTrackCode");
            return (Criteria) this;
        }

        public Criteria andAadAfterTrackCodeLessThanOrEqualTo(String value) {
            addCriterion("aad_after_track_code <=", value, "aadAfterTrackCode");
            return (Criteria) this;
        }

        public Criteria andAadAfterTrackCodeLike(String value) {
            addCriterion("aad_after_track_code like", value, "aadAfterTrackCode");
            return (Criteria) this;
        }

        public Criteria andAadAfterTrackCodeNotLike(String value) {
            addCriterion("aad_after_track_code not like", value, "aadAfterTrackCode");
            return (Criteria) this;
        }

        public Criteria andAadAfterTrackCodeIn(List<String> values) {
            addCriterion("aad_after_track_code in", values, "aadAfterTrackCode");
            return (Criteria) this;
        }

        public Criteria andAadAfterTrackCodeNotIn(List<String> values) {
            addCriterion("aad_after_track_code not in", values, "aadAfterTrackCode");
            return (Criteria) this;
        }

        public Criteria andAadAfterTrackCodeBetween(String value1, String value2) {
            addCriterion("aad_after_track_code between", value1, value2, "aadAfterTrackCode");
            return (Criteria) this;
        }

        public Criteria andAadAfterTrackCodeNotBetween(String value1, String value2) {
            addCriterion("aad_after_track_code not between", value1, value2, "aadAfterTrackCode");
            return (Criteria) this;
        }

        public Criteria andAadAfterUnitIsNull() {
            addCriterion("aad_after_unit is null");
            return (Criteria) this;
        }

        public Criteria andAadAfterUnitIsNotNull() {
            addCriterion("aad_after_unit is not null");
            return (Criteria) this;
        }

        public Criteria andAadAfterUnitEqualTo(String value) {
            addCriterion("aad_after_unit =", value, "aadAfterUnit");
            return (Criteria) this;
        }

        public Criteria andAadAfterUnitNotEqualTo(String value) {
            addCriterion("aad_after_unit <>", value, "aadAfterUnit");
            return (Criteria) this;
        }

        public Criteria andAadAfterUnitGreaterThan(String value) {
            addCriterion("aad_after_unit >", value, "aadAfterUnit");
            return (Criteria) this;
        }

        public Criteria andAadAfterUnitGreaterThanOrEqualTo(String value) {
            addCriterion("aad_after_unit >=", value, "aadAfterUnit");
            return (Criteria) this;
        }

        public Criteria andAadAfterUnitLessThan(String value) {
            addCriterion("aad_after_unit <", value, "aadAfterUnit");
            return (Criteria) this;
        }

        public Criteria andAadAfterUnitLessThanOrEqualTo(String value) {
            addCriterion("aad_after_unit <=", value, "aadAfterUnit");
            return (Criteria) this;
        }

        public Criteria andAadAfterUnitLike(String value) {
            addCriterion("aad_after_unit like", value, "aadAfterUnit");
            return (Criteria) this;
        }

        public Criteria andAadAfterUnitNotLike(String value) {
            addCriterion("aad_after_unit not like", value, "aadAfterUnit");
            return (Criteria) this;
        }

        public Criteria andAadAfterUnitIn(List<String> values) {
            addCriterion("aad_after_unit in", values, "aadAfterUnit");
            return (Criteria) this;
        }

        public Criteria andAadAfterUnitNotIn(List<String> values) {
            addCriterion("aad_after_unit not in", values, "aadAfterUnit");
            return (Criteria) this;
        }

        public Criteria andAadAfterUnitBetween(String value1, String value2) {
            addCriterion("aad_after_unit between", value1, value2, "aadAfterUnit");
            return (Criteria) this;
        }

        public Criteria andAadAfterUnitNotBetween(String value1, String value2) {
            addCriterion("aad_after_unit not between", value1, value2, "aadAfterUnit");
            return (Criteria) this;
        }

        public Criteria andAadAfterPriceIsNull() {
            addCriterion("aad_after_price is null");
            return (Criteria) this;
        }

        public Criteria andAadAfterPriceIsNotNull() {
            addCriterion("aad_after_price is not null");
            return (Criteria) this;
        }

        public Criteria andAadAfterPriceEqualTo(Double value) {
            addCriterion("aad_after_price =", value, "aadAfterPrice");
            return (Criteria) this;
        }

        public Criteria andAadAfterPriceNotEqualTo(Double value) {
            addCriterion("aad_after_price <>", value, "aadAfterPrice");
            return (Criteria) this;
        }

        public Criteria andAadAfterPriceGreaterThan(Double value) {
            addCriterion("aad_after_price >", value, "aadAfterPrice");
            return (Criteria) this;
        }

        public Criteria andAadAfterPriceGreaterThanOrEqualTo(Double value) {
            addCriterion("aad_after_price >=", value, "aadAfterPrice");
            return (Criteria) this;
        }

        public Criteria andAadAfterPriceLessThan(Double value) {
            addCriterion("aad_after_price <", value, "aadAfterPrice");
            return (Criteria) this;
        }

        public Criteria andAadAfterPriceLessThanOrEqualTo(Double value) {
            addCriterion("aad_after_price <=", value, "aadAfterPrice");
            return (Criteria) this;
        }

        public Criteria andAadAfterPriceIn(List<Double> values) {
            addCriterion("aad_after_price in", values, "aadAfterPrice");
            return (Criteria) this;
        }

        public Criteria andAadAfterPriceNotIn(List<Double> values) {
            addCriterion("aad_after_price not in", values, "aadAfterPrice");
            return (Criteria) this;
        }

        public Criteria andAadAfterPriceBetween(Double value1, Double value2) {
            addCriterion("aad_after_price between", value1, value2, "aadAfterPrice");
            return (Criteria) this;
        }

        public Criteria andAadAfterPriceNotBetween(Double value1, Double value2) {
            addCriterion("aad_after_price not between", value1, value2, "aadAfterPrice");
            return (Criteria) this;
        }

        public Criteria andAadAfterAmountIsNull() {
            addCriterion("aad_after_amount is null");
            return (Criteria) this;
        }

        public Criteria andAadAfterAmountIsNotNull() {
            addCriterion("aad_after_amount is not null");
            return (Criteria) this;
        }

        public Criteria andAadAfterAmountEqualTo(Double value) {
            addCriterion("aad_after_amount =", value, "aadAfterAmount");
            return (Criteria) this;
        }

        public Criteria andAadAfterAmountNotEqualTo(Double value) {
            addCriterion("aad_after_amount <>", value, "aadAfterAmount");
            return (Criteria) this;
        }

        public Criteria andAadAfterAmountGreaterThan(Double value) {
            addCriterion("aad_after_amount >", value, "aadAfterAmount");
            return (Criteria) this;
        }

        public Criteria andAadAfterAmountGreaterThanOrEqualTo(Double value) {
            addCriterion("aad_after_amount >=", value, "aadAfterAmount");
            return (Criteria) this;
        }

        public Criteria andAadAfterAmountLessThan(Double value) {
            addCriterion("aad_after_amount <", value, "aadAfterAmount");
            return (Criteria) this;
        }

        public Criteria andAadAfterAmountLessThanOrEqualTo(Double value) {
            addCriterion("aad_after_amount <=", value, "aadAfterAmount");
            return (Criteria) this;
        }

        public Criteria andAadAfterAmountIn(List<Double> values) {
            addCriterion("aad_after_amount in", values, "aadAfterAmount");
            return (Criteria) this;
        }

        public Criteria andAadAfterAmountNotIn(List<Double> values) {
            addCriterion("aad_after_amount not in", values, "aadAfterAmount");
            return (Criteria) this;
        }

        public Criteria andAadAfterAmountBetween(Double value1, Double value2) {
            addCriterion("aad_after_amount between", value1, value2, "aadAfterAmount");
            return (Criteria) this;
        }

        public Criteria andAadAfterAmountNotBetween(Double value1, Double value2) {
            addCriterion("aad_after_amount not between", value1, value2, "aadAfterAmount");
            return (Criteria) this;
        }

        public Criteria andAadAfterPositionIsNull() {
            addCriterion("aad_after_position is null");
            return (Criteria) this;
        }

        public Criteria andAadAfterPositionIsNotNull() {
            addCriterion("aad_after_position is not null");
            return (Criteria) this;
        }

        public Criteria andAadAfterPositionEqualTo(String value) {
            addCriterion("aad_after_position =", value, "aadAfterPosition");
            return (Criteria) this;
        }

        public Criteria andAadAfterPositionNotEqualTo(String value) {
            addCriterion("aad_after_position <>", value, "aadAfterPosition");
            return (Criteria) this;
        }

        public Criteria andAadAfterPositionGreaterThan(String value) {
            addCriterion("aad_after_position >", value, "aadAfterPosition");
            return (Criteria) this;
        }

        public Criteria andAadAfterPositionGreaterThanOrEqualTo(String value) {
            addCriterion("aad_after_position >=", value, "aadAfterPosition");
            return (Criteria) this;
        }

        public Criteria andAadAfterPositionLessThan(String value) {
            addCriterion("aad_after_position <", value, "aadAfterPosition");
            return (Criteria) this;
        }

        public Criteria andAadAfterPositionLessThanOrEqualTo(String value) {
            addCriterion("aad_after_position <=", value, "aadAfterPosition");
            return (Criteria) this;
        }

        public Criteria andAadAfterPositionLike(String value) {
            addCriterion("aad_after_position like", value, "aadAfterPosition");
            return (Criteria) this;
        }

        public Criteria andAadAfterPositionNotLike(String value) {
            addCriterion("aad_after_position not like", value, "aadAfterPosition");
            return (Criteria) this;
        }

        public Criteria andAadAfterPositionIn(List<String> values) {
            addCriterion("aad_after_position in", values, "aadAfterPosition");
            return (Criteria) this;
        }

        public Criteria andAadAfterPositionNotIn(List<String> values) {
            addCriterion("aad_after_position not in", values, "aadAfterPosition");
            return (Criteria) this;
        }

        public Criteria andAadAfterPositionBetween(String value1, String value2) {
            addCriterion("aad_after_position between", value1, value2, "aadAfterPosition");
            return (Criteria) this;
        }

        public Criteria andAadAfterPositionNotBetween(String value1, String value2) {
            addCriterion("aad_after_position not between", value1, value2, "aadAfterPosition");
            return (Criteria) this;
        }

        public Criteria andAadAfterWhiIdIsNull() {
            addCriterion("aad_after_whi_id is null");
            return (Criteria) this;
        }

        public Criteria andAadAfterWhiIdIsNotNull() {
            addCriterion("aad_after_whi_id is not null");
            return (Criteria) this;
        }

        public Criteria andAadAfterWhiIdEqualTo(Integer value) {
            addCriterion("aad_after_whi_id =", value, "aadAfterWhiId");
            return (Criteria) this;
        }

        public Criteria andAadAfterWhiIdNotEqualTo(Integer value) {
            addCriterion("aad_after_whi_id <>", value, "aadAfterWhiId");
            return (Criteria) this;
        }

        public Criteria andAadAfterWhiIdGreaterThan(Integer value) {
            addCriterion("aad_after_whi_id >", value, "aadAfterWhiId");
            return (Criteria) this;
        }

        public Criteria andAadAfterWhiIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("aad_after_whi_id >=", value, "aadAfterWhiId");
            return (Criteria) this;
        }

        public Criteria andAadAfterWhiIdLessThan(Integer value) {
            addCriterion("aad_after_whi_id <", value, "aadAfterWhiId");
            return (Criteria) this;
        }

        public Criteria andAadAfterWhiIdLessThanOrEqualTo(Integer value) {
            addCriterion("aad_after_whi_id <=", value, "aadAfterWhiId");
            return (Criteria) this;
        }

        public Criteria andAadAfterWhiIdIn(List<Integer> values) {
            addCriterion("aad_after_whi_id in", values, "aadAfterWhiId");
            return (Criteria) this;
        }

        public Criteria andAadAfterWhiIdNotIn(List<Integer> values) {
            addCriterion("aad_after_whi_id not in", values, "aadAfterWhiId");
            return (Criteria) this;
        }

        public Criteria andAadAfterWhiIdBetween(Integer value1, Integer value2) {
            addCriterion("aad_after_whi_id between", value1, value2, "aadAfterWhiId");
            return (Criteria) this;
        }

        public Criteria andAadAfterWhiIdNotBetween(Integer value1, Integer value2) {
            addCriterion("aad_after_whi_id not between", value1, value2, "aadAfterWhiId");
            return (Criteria) this;
        }

        public Criteria andAadAfterIfFinishedProductIsNull() {
            addCriterion("aad_after_if_finished_product is null");
            return (Criteria) this;
        }

        public Criteria andAadAfterIfFinishedProductIsNotNull() {
            addCriterion("aad_after_if_finished_product is not null");
            return (Criteria) this;
        }

        public Criteria andAadAfterIfFinishedProductEqualTo(Integer value) {
            addCriterion("aad_after_if_finished_product =", value, "aadAfterIfFinishedProduct");
            return (Criteria) this;
        }

        public Criteria andAadAfterIfFinishedProductNotEqualTo(Integer value) {
            addCriterion("aad_after_if_finished_product <>", value, "aadAfterIfFinishedProduct");
            return (Criteria) this;
        }

        public Criteria andAadAfterIfFinishedProductGreaterThan(Integer value) {
            addCriterion("aad_after_if_finished_product >", value, "aadAfterIfFinishedProduct");
            return (Criteria) this;
        }

        public Criteria andAadAfterIfFinishedProductGreaterThanOrEqualTo(Integer value) {
            addCriterion("aad_after_if_finished_product >=", value, "aadAfterIfFinishedProduct");
            return (Criteria) this;
        }

        public Criteria andAadAfterIfFinishedProductLessThan(Integer value) {
            addCriterion("aad_after_if_finished_product <", value, "aadAfterIfFinishedProduct");
            return (Criteria) this;
        }

        public Criteria andAadAfterIfFinishedProductLessThanOrEqualTo(Integer value) {
            addCriterion("aad_after_if_finished_product <=", value, "aadAfterIfFinishedProduct");
            return (Criteria) this;
        }

        public Criteria andAadAfterIfFinishedProductIn(List<Integer> values) {
            addCriterion("aad_after_if_finished_product in", values, "aadAfterIfFinishedProduct");
            return (Criteria) this;
        }

        public Criteria andAadAfterIfFinishedProductNotIn(List<Integer> values) {
            addCriterion("aad_after_if_finished_product not in", values, "aadAfterIfFinishedProduct");
            return (Criteria) this;
        }

        public Criteria andAadAfterIfFinishedProductBetween(Integer value1, Integer value2) {
            addCriterion("aad_after_if_finished_product between", value1, value2, "aadAfterIfFinishedProduct");
            return (Criteria) this;
        }

        public Criteria andAadAfterIfFinishedProductNotBetween(Integer value1, Integer value2) {
            addCriterion("aad_after_if_finished_product not between", value1, value2, "aadAfterIfFinishedProduct");
            return (Criteria) this;
        }

        public Criteria andAadAfterRemarkIsNull() {
            addCriterion("aad_after_remark is null");
            return (Criteria) this;
        }

        public Criteria andAadAfterRemarkIsNotNull() {
            addCriterion("aad_after_remark is not null");
            return (Criteria) this;
        }

        public Criteria andAadAfterRemarkEqualTo(String value) {
            addCriterion("aad_after_remark =", value, "aadAfterRemark");
            return (Criteria) this;
        }

        public Criteria andAadAfterRemarkNotEqualTo(String value) {
            addCriterion("aad_after_remark <>", value, "aadAfterRemark");
            return (Criteria) this;
        }

        public Criteria andAadAfterRemarkGreaterThan(String value) {
            addCriterion("aad_after_remark >", value, "aadAfterRemark");
            return (Criteria) this;
        }

        public Criteria andAadAfterRemarkGreaterThanOrEqualTo(String value) {
            addCriterion("aad_after_remark >=", value, "aadAfterRemark");
            return (Criteria) this;
        }

        public Criteria andAadAfterRemarkLessThan(String value) {
            addCriterion("aad_after_remark <", value, "aadAfterRemark");
            return (Criteria) this;
        }

        public Criteria andAadAfterRemarkLessThanOrEqualTo(String value) {
            addCriterion("aad_after_remark <=", value, "aadAfterRemark");
            return (Criteria) this;
        }

        public Criteria andAadAfterRemarkLike(String value) {
            addCriterion("aad_after_remark like", value, "aadAfterRemark");
            return (Criteria) this;
        }

        public Criteria andAadAfterRemarkNotLike(String value) {
            addCriterion("aad_after_remark not like", value, "aadAfterRemark");
            return (Criteria) this;
        }

        public Criteria andAadAfterRemarkIn(List<String> values) {
            addCriterion("aad_after_remark in", values, "aadAfterRemark");
            return (Criteria) this;
        }

        public Criteria andAadAfterRemarkNotIn(List<String> values) {
            addCriterion("aad_after_remark not in", values, "aadAfterRemark");
            return (Criteria) this;
        }

        public Criteria andAadAfterRemarkBetween(String value1, String value2) {
            addCriterion("aad_after_remark between", value1, value2, "aadAfterRemark");
            return (Criteria) this;
        }

        public Criteria andAadAfterRemarkNotBetween(String value1, String value2) {
            addCriterion("aad_after_remark not between", value1, value2, "aadAfterRemark");
            return (Criteria) this;
        }

        public Criteria andAadAfterMatTypeIsNull() {
            addCriterion("aad_after_mat_type is null");
            return (Criteria) this;
        }

        public Criteria andAadAfterMatTypeIsNotNull() {
            addCriterion("aad_after_mat_type is not null");
            return (Criteria) this;
        }

        public Criteria andAadAfterMatTypeEqualTo(Integer value) {
            addCriterion("aad_after_mat_type =", value, "aadAfterMatType");
            return (Criteria) this;
        }

        public Criteria andAadAfterMatTypeNotEqualTo(Integer value) {
            addCriterion("aad_after_mat_type <>", value, "aadAfterMatType");
            return (Criteria) this;
        }

        public Criteria andAadAfterMatTypeGreaterThan(Integer value) {
            addCriterion("aad_after_mat_type >", value, "aadAfterMatType");
            return (Criteria) this;
        }

        public Criteria andAadAfterMatTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("aad_after_mat_type >=", value, "aadAfterMatType");
            return (Criteria) this;
        }

        public Criteria andAadAfterMatTypeLessThan(Integer value) {
            addCriterion("aad_after_mat_type <", value, "aadAfterMatType");
            return (Criteria) this;
        }

        public Criteria andAadAfterMatTypeLessThanOrEqualTo(Integer value) {
            addCriterion("aad_after_mat_type <=", value, "aadAfterMatType");
            return (Criteria) this;
        }

        public Criteria andAadAfterMatTypeIn(List<Integer> values) {
            addCriterion("aad_after_mat_type in", values, "aadAfterMatType");
            return (Criteria) this;
        }

        public Criteria andAadAfterMatTypeNotIn(List<Integer> values) {
            addCriterion("aad_after_mat_type not in", values, "aadAfterMatType");
            return (Criteria) this;
        }

        public Criteria andAadAfterMatTypeBetween(Integer value1, Integer value2) {
            addCriterion("aad_after_mat_type between", value1, value2, "aadAfterMatType");
            return (Criteria) this;
        }

        public Criteria andAadAfterMatTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("aad_after_mat_type not between", value1, value2, "aadAfterMatType");
            return (Criteria) this;
        }

        public Criteria andAadAfterCaseNoIsNull() {
            addCriterion("aad_after_case_no is null");
            return (Criteria) this;
        }

        public Criteria andAadAfterCaseNoIsNotNull() {
            addCriterion("aad_after_case_no is not null");
            return (Criteria) this;
        }

        public Criteria andAadAfterCaseNoEqualTo(String value) {
            addCriterion("aad_after_case_no =", value, "aadAfterCaseNo");
            return (Criteria) this;
        }

        public Criteria andAadAfterCaseNoNotEqualTo(String value) {
            addCriterion("aad_after_case_no <>", value, "aadAfterCaseNo");
            return (Criteria) this;
        }

        public Criteria andAadAfterCaseNoGreaterThan(String value) {
            addCriterion("aad_after_case_no >", value, "aadAfterCaseNo");
            return (Criteria) this;
        }

        public Criteria andAadAfterCaseNoGreaterThanOrEqualTo(String value) {
            addCriterion("aad_after_case_no >=", value, "aadAfterCaseNo");
            return (Criteria) this;
        }

        public Criteria andAadAfterCaseNoLessThan(String value) {
            addCriterion("aad_after_case_no <", value, "aadAfterCaseNo");
            return (Criteria) this;
        }

        public Criteria andAadAfterCaseNoLessThanOrEqualTo(String value) {
            addCriterion("aad_after_case_no <=", value, "aadAfterCaseNo");
            return (Criteria) this;
        }

        public Criteria andAadAfterCaseNoLike(String value) {
            addCriterion("aad_after_case_no like", value, "aadAfterCaseNo");
            return (Criteria) this;
        }

        public Criteria andAadAfterCaseNoNotLike(String value) {
            addCriterion("aad_after_case_no not like", value, "aadAfterCaseNo");
            return (Criteria) this;
        }

        public Criteria andAadAfterCaseNoIn(List<String> values) {
            addCriterion("aad_after_case_no in", values, "aadAfterCaseNo");
            return (Criteria) this;
        }

        public Criteria andAadAfterCaseNoNotIn(List<String> values) {
            addCriterion("aad_after_case_no not in", values, "aadAfterCaseNo");
            return (Criteria) this;
        }

        public Criteria andAadAfterCaseNoBetween(String value1, String value2) {
            addCriterion("aad_after_case_no between", value1, value2, "aadAfterCaseNo");
            return (Criteria) this;
        }

        public Criteria andAadAfterCaseNoNotBetween(String value1, String value2) {
            addCriterion("aad_after_case_no not between", value1, value2, "aadAfterCaseNo");
            return (Criteria) this;
        }

        public Criteria andAadAfterBoxingDateIsNull() {
            addCriterion("aad_after_boxing_date is null");
            return (Criteria) this;
        }

        public Criteria andAadAfterBoxingDateIsNotNull() {
            addCriterion("aad_after_boxing_date is not null");
            return (Criteria) this;
        }

        public Criteria andAadAfterBoxingDateEqualTo(Date value) {
            addCriterion("aad_after_boxing_date =", value, "aadAfterBoxingDate");
            return (Criteria) this;
        }

        public Criteria andAadAfterBoxingDateNotEqualTo(Date value) {
            addCriterion("aad_after_boxing_date <>", value, "aadAfterBoxingDate");
            return (Criteria) this;
        }

        public Criteria andAadAfterBoxingDateGreaterThan(Date value) {
            addCriterion("aad_after_boxing_date >", value, "aadAfterBoxingDate");
            return (Criteria) this;
        }

        public Criteria andAadAfterBoxingDateGreaterThanOrEqualTo(Date value) {
            addCriterion("aad_after_boxing_date >=", value, "aadAfterBoxingDate");
            return (Criteria) this;
        }

        public Criteria andAadAfterBoxingDateLessThan(Date value) {
            addCriterion("aad_after_boxing_date <", value, "aadAfterBoxingDate");
            return (Criteria) this;
        }

        public Criteria andAadAfterBoxingDateLessThanOrEqualTo(Date value) {
            addCriterion("aad_after_boxing_date <=", value, "aadAfterBoxingDate");
            return (Criteria) this;
        }

        public Criteria andAadAfterBoxingDateIn(List<Date> values) {
            addCriterion("aad_after_boxing_date in", values, "aadAfterBoxingDate");
            return (Criteria) this;
        }

        public Criteria andAadAfterBoxingDateNotIn(List<Date> values) {
            addCriterion("aad_after_boxing_date not in", values, "aadAfterBoxingDate");
            return (Criteria) this;
        }

        public Criteria andAadAfterBoxingDateBetween(Date value1, Date value2) {
            addCriterion("aad_after_boxing_date between", value1, value2, "aadAfterBoxingDate");
            return (Criteria) this;
        }

        public Criteria andAadAfterBoxingDateNotBetween(Date value1, Date value2) {
            addCriterion("aad_after_boxing_date not between", value1, value2, "aadAfterBoxingDate");
            return (Criteria) this;
        }

        public Criteria andAadAfterStockTypeIsNull() {
            addCriterion("aad_after_stock_type is null");
            return (Criteria) this;
        }

        public Criteria andAadAfterStockTypeIsNotNull() {
            addCriterion("aad_after_stock_type is not null");
            return (Criteria) this;
        }

        public Criteria andAadAfterStockTypeEqualTo(Integer value) {
            addCriterion("aad_after_stock_type =", value, "aadAfterStockType");
            return (Criteria) this;
        }

        public Criteria andAadAfterStockTypeNotEqualTo(Integer value) {
            addCriterion("aad_after_stock_type <>", value, "aadAfterStockType");
            return (Criteria) this;
        }

        public Criteria andAadAfterStockTypeGreaterThan(Integer value) {
            addCriterion("aad_after_stock_type >", value, "aadAfterStockType");
            return (Criteria) this;
        }

        public Criteria andAadAfterStockTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("aad_after_stock_type >=", value, "aadAfterStockType");
            return (Criteria) this;
        }

        public Criteria andAadAfterStockTypeLessThan(Integer value) {
            addCriterion("aad_after_stock_type <", value, "aadAfterStockType");
            return (Criteria) this;
        }

        public Criteria andAadAfterStockTypeLessThanOrEqualTo(Integer value) {
            addCriterion("aad_after_stock_type <=", value, "aadAfterStockType");
            return (Criteria) this;
        }

        public Criteria andAadAfterStockTypeIn(List<Integer> values) {
            addCriterion("aad_after_stock_type in", values, "aadAfterStockType");
            return (Criteria) this;
        }

        public Criteria andAadAfterStockTypeNotIn(List<Integer> values) {
            addCriterion("aad_after_stock_type not in", values, "aadAfterStockType");
            return (Criteria) this;
        }

        public Criteria andAadAfterStockTypeBetween(Integer value1, Integer value2) {
            addCriterion("aad_after_stock_type between", value1, value2, "aadAfterStockType");
            return (Criteria) this;
        }

        public Criteria andAadAfterStockTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("aad_after_stock_type not between", value1, value2, "aadAfterStockType");
            return (Criteria) this;
        }

        public Criteria andAadAfterSpecialInstructionsIsNull() {
            addCriterion("aad_after_special_instructions is null");
            return (Criteria) this;
        }

        public Criteria andAadAfterSpecialInstructionsIsNotNull() {
            addCriterion("aad_after_special_instructions is not null");
            return (Criteria) this;
        }

        public Criteria andAadAfterSpecialInstructionsEqualTo(String value) {
            addCriterion("aad_after_special_instructions =", value, "aadAfterSpecialInstructions");
            return (Criteria) this;
        }

        public Criteria andAadAfterSpecialInstructionsNotEqualTo(String value) {
            addCriterion("aad_after_special_instructions <>", value, "aadAfterSpecialInstructions");
            return (Criteria) this;
        }

        public Criteria andAadAfterSpecialInstructionsGreaterThan(String value) {
            addCriterion("aad_after_special_instructions >", value, "aadAfterSpecialInstructions");
            return (Criteria) this;
        }

        public Criteria andAadAfterSpecialInstructionsGreaterThanOrEqualTo(String value) {
            addCriterion("aad_after_special_instructions >=", value, "aadAfterSpecialInstructions");
            return (Criteria) this;
        }

        public Criteria andAadAfterSpecialInstructionsLessThan(String value) {
            addCriterion("aad_after_special_instructions <", value, "aadAfterSpecialInstructions");
            return (Criteria) this;
        }

        public Criteria andAadAfterSpecialInstructionsLessThanOrEqualTo(String value) {
            addCriterion("aad_after_special_instructions <=", value, "aadAfterSpecialInstructions");
            return (Criteria) this;
        }

        public Criteria andAadAfterSpecialInstructionsLike(String value) {
            addCriterion("aad_after_special_instructions like", value, "aadAfterSpecialInstructions");
            return (Criteria) this;
        }

        public Criteria andAadAfterSpecialInstructionsNotLike(String value) {
            addCriterion("aad_after_special_instructions not like", value, "aadAfterSpecialInstructions");
            return (Criteria) this;
        }

        public Criteria andAadAfterSpecialInstructionsIn(List<String> values) {
            addCriterion("aad_after_special_instructions in", values, "aadAfterSpecialInstructions");
            return (Criteria) this;
        }

        public Criteria andAadAfterSpecialInstructionsNotIn(List<String> values) {
            addCriterion("aad_after_special_instructions not in", values, "aadAfterSpecialInstructions");
            return (Criteria) this;
        }

        public Criteria andAadAfterSpecialInstructionsBetween(String value1, String value2) {
            addCriterion("aad_after_special_instructions between", value1, value2, "aadAfterSpecialInstructions");
            return (Criteria) this;
        }

        public Criteria andAadAfterSpecialInstructionsNotBetween(String value1, String value2) {
            addCriterion("aad_after_special_instructions not between", value1, value2, "aadAfterSpecialInstructions");
            return (Criteria) this;
        }

        public Criteria andAadApplicantIsNull() {
            addCriterion("aad_applicant is null");
            return (Criteria) this;
        }

        public Criteria andAadApplicantIsNotNull() {
            addCriterion("aad_applicant is not null");
            return (Criteria) this;
        }

        public Criteria andAadApplicantEqualTo(String value) {
            addCriterion("aad_applicant =", value, "aadApplicant");
            return (Criteria) this;
        }

        public Criteria andAadApplicantNotEqualTo(String value) {
            addCriterion("aad_applicant <>", value, "aadApplicant");
            return (Criteria) this;
        }

        public Criteria andAadApplicantGreaterThan(String value) {
            addCriterion("aad_applicant >", value, "aadApplicant");
            return (Criteria) this;
        }

        public Criteria andAadApplicantGreaterThanOrEqualTo(String value) {
            addCriterion("aad_applicant >=", value, "aadApplicant");
            return (Criteria) this;
        }

        public Criteria andAadApplicantLessThan(String value) {
            addCriterion("aad_applicant <", value, "aadApplicant");
            return (Criteria) this;
        }

        public Criteria andAadApplicantLessThanOrEqualTo(String value) {
            addCriterion("aad_applicant <=", value, "aadApplicant");
            return (Criteria) this;
        }

        public Criteria andAadApplicantLike(String value) {
            addCriterion("aad_applicant like", value, "aadApplicant");
            return (Criteria) this;
        }

        public Criteria andAadApplicantNotLike(String value) {
            addCriterion("aad_applicant not like", value, "aadApplicant");
            return (Criteria) this;
        }

        public Criteria andAadApplicantIn(List<String> values) {
            addCriterion("aad_applicant in", values, "aadApplicant");
            return (Criteria) this;
        }

        public Criteria andAadApplicantNotIn(List<String> values) {
            addCriterion("aad_applicant not in", values, "aadApplicant");
            return (Criteria) this;
        }

        public Criteria andAadApplicantBetween(String value1, String value2) {
            addCriterion("aad_applicant between", value1, value2, "aadApplicant");
            return (Criteria) this;
        }

        public Criteria andAadApplicantNotBetween(String value1, String value2) {
            addCriterion("aad_applicant not between", value1, value2, "aadApplicant");
            return (Criteria) this;
        }

        public Criteria andAadApplDateIsNull() {
            addCriterion("aad_appl_date is null");
            return (Criteria) this;
        }

        public Criteria andAadApplDateIsNotNull() {
            addCriterion("aad_appl_date is not null");
            return (Criteria) this;
        }

        public Criteria andAadApplDateEqualTo(Date value) {
            addCriterionForJDBCDate("aad_appl_date =", value, "aadApplDate");
            return (Criteria) this;
        }

        public Criteria andAadApplDateNotEqualTo(Date value) {
            addCriterionForJDBCDate("aad_appl_date <>", value, "aadApplDate");
            return (Criteria) this;
        }

        public Criteria andAadApplDateGreaterThan(Date value) {
            addCriterionForJDBCDate("aad_appl_date >", value, "aadApplDate");
            return (Criteria) this;
        }

        public Criteria andAadApplDateGreaterThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("aad_appl_date >=", value, "aadApplDate");
            return (Criteria) this;
        }

        public Criteria andAadApplDateLessThan(Date value) {
            addCriterionForJDBCDate("aad_appl_date <", value, "aadApplDate");
            return (Criteria) this;
        }

        public Criteria andAadApplDateLessThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("aad_appl_date <=", value, "aadApplDate");
            return (Criteria) this;
        }

        public Criteria andAadApplDateIn(List<Date> values) {
            addCriterionForJDBCDate("aad_appl_date in", values, "aadApplDate");
            return (Criteria) this;
        }

        public Criteria andAadApplDateNotIn(List<Date> values) {
            addCriterionForJDBCDate("aad_appl_date not in", values, "aadApplDate");
            return (Criteria) this;
        }

        public Criteria andAadApplDateBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("aad_appl_date between", value1, value2, "aadApplDate");
            return (Criteria) this;
        }

        public Criteria andAadApplDateNotBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("aad_appl_date not between", value1, value2, "aadApplDate");
            return (Criteria) this;
        }

        public Criteria andAadReviewerIsNull() {
            addCriterion("aad_reviewer is null");
            return (Criteria) this;
        }

        public Criteria andAadReviewerIsNotNull() {
            addCriterion("aad_reviewer is not null");
            return (Criteria) this;
        }

        public Criteria andAadReviewerEqualTo(String value) {
            addCriterion("aad_reviewer =", value, "aadReviewer");
            return (Criteria) this;
        }

        public Criteria andAadReviewerNotEqualTo(String value) {
            addCriterion("aad_reviewer <>", value, "aadReviewer");
            return (Criteria) this;
        }

        public Criteria andAadReviewerGreaterThan(String value) {
            addCriterion("aad_reviewer >", value, "aadReviewer");
            return (Criteria) this;
        }

        public Criteria andAadReviewerGreaterThanOrEqualTo(String value) {
            addCriterion("aad_reviewer >=", value, "aadReviewer");
            return (Criteria) this;
        }

        public Criteria andAadReviewerLessThan(String value) {
            addCriterion("aad_reviewer <", value, "aadReviewer");
            return (Criteria) this;
        }

        public Criteria andAadReviewerLessThanOrEqualTo(String value) {
            addCriterion("aad_reviewer <=", value, "aadReviewer");
            return (Criteria) this;
        }

        public Criteria andAadReviewerLike(String value) {
            addCriterion("aad_reviewer like", value, "aadReviewer");
            return (Criteria) this;
        }

        public Criteria andAadReviewerNotLike(String value) {
            addCriterion("aad_reviewer not like", value, "aadReviewer");
            return (Criteria) this;
        }

        public Criteria andAadReviewerIn(List<String> values) {
            addCriterion("aad_reviewer in", values, "aadReviewer");
            return (Criteria) this;
        }

        public Criteria andAadReviewerNotIn(List<String> values) {
            addCriterion("aad_reviewer not in", values, "aadReviewer");
            return (Criteria) this;
        }

        public Criteria andAadReviewerBetween(String value1, String value2) {
            addCriterion("aad_reviewer between", value1, value2, "aadReviewer");
            return (Criteria) this;
        }

        public Criteria andAadReviewerNotBetween(String value1, String value2) {
            addCriterion("aad_reviewer not between", value1, value2, "aadReviewer");
            return (Criteria) this;
        }

        public Criteria andAadReviewDateIsNull() {
            addCriterion("aad_review_date is null");
            return (Criteria) this;
        }

        public Criteria andAadReviewDateIsNotNull() {
            addCriterion("aad_review_date is not null");
            return (Criteria) this;
        }

        public Criteria andAadReviewDateEqualTo(Date value) {
            addCriterionForJDBCDate("aad_review_date =", value, "aadReviewDate");
            return (Criteria) this;
        }

        public Criteria andAadReviewDateNotEqualTo(Date value) {
            addCriterionForJDBCDate("aad_review_date <>", value, "aadReviewDate");
            return (Criteria) this;
        }

        public Criteria andAadReviewDateGreaterThan(Date value) {
            addCriterionForJDBCDate("aad_review_date >", value, "aadReviewDate");
            return (Criteria) this;
        }

        public Criteria andAadReviewDateGreaterThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("aad_review_date >=", value, "aadReviewDate");
            return (Criteria) this;
        }

        public Criteria andAadReviewDateLessThan(Date value) {
            addCriterionForJDBCDate("aad_review_date <", value, "aadReviewDate");
            return (Criteria) this;
        }

        public Criteria andAadReviewDateLessThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("aad_review_date <=", value, "aadReviewDate");
            return (Criteria) this;
        }

        public Criteria andAadReviewDateIn(List<Date> values) {
            addCriterionForJDBCDate("aad_review_date in", values, "aadReviewDate");
            return (Criteria) this;
        }

        public Criteria andAadReviewDateNotIn(List<Date> values) {
            addCriterionForJDBCDate("aad_review_date not in", values, "aadReviewDate");
            return (Criteria) this;
        }

        public Criteria andAadReviewDateBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("aad_review_date between", value1, value2, "aadReviewDate");
            return (Criteria) this;
        }

        public Criteria andAadReviewDateNotBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("aad_review_date not between", value1, value2, "aadReviewDate");
            return (Criteria) this;
        }

        public Criteria andAadApprovalCommentsIsNull() {
            addCriterion("aad_approval_comments is null");
            return (Criteria) this;
        }

        public Criteria andAadApprovalCommentsIsNotNull() {
            addCriterion("aad_approval_comments is not null");
            return (Criteria) this;
        }

        public Criteria andAadApprovalCommentsEqualTo(String value) {
            addCriterion("aad_approval_comments =", value, "aadApprovalComments");
            return (Criteria) this;
        }

        public Criteria andAadApprovalCommentsNotEqualTo(String value) {
            addCriterion("aad_approval_comments <>", value, "aadApprovalComments");
            return (Criteria) this;
        }

        public Criteria andAadApprovalCommentsGreaterThan(String value) {
            addCriterion("aad_approval_comments >", value, "aadApprovalComments");
            return (Criteria) this;
        }

        public Criteria andAadApprovalCommentsGreaterThanOrEqualTo(String value) {
            addCriterion("aad_approval_comments >=", value, "aadApprovalComments");
            return (Criteria) this;
        }

        public Criteria andAadApprovalCommentsLessThan(String value) {
            addCriterion("aad_approval_comments <", value, "aadApprovalComments");
            return (Criteria) this;
        }

        public Criteria andAadApprovalCommentsLessThanOrEqualTo(String value) {
            addCriterion("aad_approval_comments <=", value, "aadApprovalComments");
            return (Criteria) this;
        }

        public Criteria andAadApprovalCommentsLike(String value) {
            addCriterion("aad_approval_comments like", value, "aadApprovalComments");
            return (Criteria) this;
        }

        public Criteria andAadApprovalCommentsNotLike(String value) {
            addCriterion("aad_approval_comments not like", value, "aadApprovalComments");
            return (Criteria) this;
        }

        public Criteria andAadApprovalCommentsIn(List<String> values) {
            addCriterion("aad_approval_comments in", values, "aadApprovalComments");
            return (Criteria) this;
        }

        public Criteria andAadApprovalCommentsNotIn(List<String> values) {
            addCriterion("aad_approval_comments not in", values, "aadApprovalComments");
            return (Criteria) this;
        }

        public Criteria andAadApprovalCommentsBetween(String value1, String value2) {
            addCriterion("aad_approval_comments between", value1, value2, "aadApprovalComments");
            return (Criteria) this;
        }

        public Criteria andAadApprovalCommentsNotBetween(String value1, String value2) {
            addCriterion("aad_approval_comments not between", value1, value2, "aadApprovalComments");
            return (Criteria) this;
        }

        public Criteria andAadStatusIsNull() {
            addCriterion("aad_status is null");
            return (Criteria) this;
        }

        public Criteria andAadStatusIsNotNull() {
            addCriterion("aad_status is not null");
            return (Criteria) this;
        }

        public Criteria andAadStatusEqualTo(Integer value) {
            addCriterion("aad_status =", value, "aadStatus");
            return (Criteria) this;
        }

        public Criteria andAadStatusNotEqualTo(Integer value) {
            addCriterion("aad_status <>", value, "aadStatus");
            return (Criteria) this;
        }

        public Criteria andAadStatusGreaterThan(Integer value) {
            addCriterion("aad_status >", value, "aadStatus");
            return (Criteria) this;
        }

        public Criteria andAadStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("aad_status >=", value, "aadStatus");
            return (Criteria) this;
        }

        public Criteria andAadStatusLessThan(Integer value) {
            addCriterion("aad_status <", value, "aadStatus");
            return (Criteria) this;
        }

        public Criteria andAadStatusLessThanOrEqualTo(Integer value) {
            addCriterion("aad_status <=", value, "aadStatus");
            return (Criteria) this;
        }

        public Criteria andAadStatusIn(List<Integer> values) {
            addCriterion("aad_status in", values, "aadStatus");
            return (Criteria) this;
        }

        public Criteria andAadStatusNotIn(List<Integer> values) {
            addCriterion("aad_status not in", values, "aadStatus");
            return (Criteria) this;
        }

        public Criteria andAadStatusBetween(Integer value1, Integer value2) {
            addCriterion("aad_status between", value1, value2, "aadStatus");
            return (Criteria) this;
        }

        public Criteria andAadStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("aad_status not between", value1, value2, "aadStatus");
            return (Criteria) this;
        }

        public Criteria andAadItyIdIsNull() {
            addCriterion("aad_ity_id is null");
            return (Criteria) this;
        }

        public Criteria andAadItyIdIsNotNull() {
            addCriterion("aad_ity_id is not null");
            return (Criteria) this;
        }

        public Criteria andAadItyIdEqualTo(Integer value) {
            addCriterion("aad_ity_id =", value, "aadItyId");
            return (Criteria) this;
        }

        public Criteria andAadItyIdNotEqualTo(Integer value) {
            addCriterion("aad_ity_id <>", value, "aadItyId");
            return (Criteria) this;
        }

        public Criteria andAadItyIdGreaterThan(Integer value) {
            addCriterion("aad_ity_id >", value, "aadItyId");
            return (Criteria) this;
        }

        public Criteria andAadItyIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("aad_ity_id >=", value, "aadItyId");
            return (Criteria) this;
        }

        public Criteria andAadItyIdLessThan(Integer value) {
            addCriterion("aad_ity_id <", value, "aadItyId");
            return (Criteria) this;
        }

        public Criteria andAadItyIdLessThanOrEqualTo(Integer value) {
            addCriterion("aad_ity_id <=", value, "aadItyId");
            return (Criteria) this;
        }

        public Criteria andAadItyIdIn(List<Integer> values) {
            addCriterion("aad_ity_id in", values, "aadItyId");
            return (Criteria) this;
        }

        public Criteria andAadItyIdNotIn(List<Integer> values) {
            addCriterion("aad_ity_id not in", values, "aadItyId");
            return (Criteria) this;
        }

        public Criteria andAadItyIdBetween(Integer value1, Integer value2) {
            addCriterion("aad_ity_id between", value1, value2, "aadItyId");
            return (Criteria) this;
        }

        public Criteria andAadItyIdNotBetween(Integer value1, Integer value2) {
            addCriterion("aad_ity_id not between", value1, value2, "aadItyId");
            return (Criteria) this;
        }

        public Criteria andAadAdjOrderCodeIsNull() {
            addCriterion("aad_adj_order_code is null");
            return (Criteria) this;
        }

        public Criteria andAadAdjOrderCodeIsNotNull() {
            addCriterion("aad_adj_order_code is not null");
            return (Criteria) this;
        }

        public Criteria andAadAdjOrderCodeEqualTo(String value) {
            addCriterion("aad_adj_order_code =", value, "aadAdjOrderCode");
            return (Criteria) this;
        }

        public Criteria andAadAdjOrderCodeNotEqualTo(String value) {
            addCriterion("aad_adj_order_code <>", value, "aadAdjOrderCode");
            return (Criteria) this;
        }

        public Criteria andAadAdjOrderCodeGreaterThan(String value) {
            addCriterion("aad_adj_order_code >", value, "aadAdjOrderCode");
            return (Criteria) this;
        }

        public Criteria andAadAdjOrderCodeGreaterThanOrEqualTo(String value) {
            addCriterion("aad_adj_order_code >=", value, "aadAdjOrderCode");
            return (Criteria) this;
        }

        public Criteria andAadAdjOrderCodeLessThan(String value) {
            addCriterion("aad_adj_order_code <", value, "aadAdjOrderCode");
            return (Criteria) this;
        }

        public Criteria andAadAdjOrderCodeLessThanOrEqualTo(String value) {
            addCriterion("aad_adj_order_code <=", value, "aadAdjOrderCode");
            return (Criteria) this;
        }

        public Criteria andAadAdjOrderCodeLike(String value) {
            addCriterion("aad_adj_order_code like", value, "aadAdjOrderCode");
            return (Criteria) this;
        }

        public Criteria andAadAdjOrderCodeNotLike(String value) {
            addCriterion("aad_adj_order_code not like", value, "aadAdjOrderCode");
            return (Criteria) this;
        }

        public Criteria andAadAdjOrderCodeIn(List<String> values) {
            addCriterion("aad_adj_order_code in", values, "aadAdjOrderCode");
            return (Criteria) this;
        }

        public Criteria andAadAdjOrderCodeNotIn(List<String> values) {
            addCriterion("aad_adj_order_code not in", values, "aadAdjOrderCode");
            return (Criteria) this;
        }

        public Criteria andAadAdjOrderCodeBetween(String value1, String value2) {
            addCriterion("aad_adj_order_code between", value1, value2, "aadAdjOrderCode");
            return (Criteria) this;
        }

        public Criteria andAadAdjOrderCodeNotBetween(String value1, String value2) {
            addCriterion("aad_adj_order_code not between", value1, value2, "aadAdjOrderCode");
            return (Criteria) this;
        }

        public Criteria andAadBeAfFlagIsNull() {
            addCriterion("aad_be_af_flag is null");
            return (Criteria) this;
        }

        public Criteria andAadBeAfFlagIsNotNull() {
            addCriterion("aad_be_af_flag is not null");
            return (Criteria) this;
        }

        public Criteria andAadBeAfFlagEqualTo(Integer value) {
            addCriterion("aad_be_af_flag =", value, "aadBeAfFlag");
            return (Criteria) this;
        }

        public Criteria andAadBeAfFlagNotEqualTo(Integer value) {
            addCriterion("aad_be_af_flag <>", value, "aadBeAfFlag");
            return (Criteria) this;
        }

        public Criteria andAadBeAfFlagGreaterThan(Integer value) {
            addCriterion("aad_be_af_flag >", value, "aadBeAfFlag");
            return (Criteria) this;
        }

        public Criteria andAadBeAfFlagGreaterThanOrEqualTo(Integer value) {
            addCriterion("aad_be_af_flag >=", value, "aadBeAfFlag");
            return (Criteria) this;
        }

        public Criteria andAadBeAfFlagLessThan(Integer value) {
            addCriterion("aad_be_af_flag <", value, "aadBeAfFlag");
            return (Criteria) this;
        }

        public Criteria andAadBeAfFlagLessThanOrEqualTo(Integer value) {
            addCriterion("aad_be_af_flag <=", value, "aadBeAfFlag");
            return (Criteria) this;
        }

        public Criteria andAadBeAfFlagIn(List<Integer> values) {
            addCriterion("aad_be_af_flag in", values, "aadBeAfFlag");
            return (Criteria) this;
        }

        public Criteria andAadBeAfFlagNotIn(List<Integer> values) {
            addCriterion("aad_be_af_flag not in", values, "aadBeAfFlag");
            return (Criteria) this;
        }

        public Criteria andAadBeAfFlagBetween(Integer value1, Integer value2) {
            addCriterion("aad_be_af_flag between", value1, value2, "aadBeAfFlag");
            return (Criteria) this;
        }

        public Criteria andAadBeAfFlagNotBetween(Integer value1, Integer value2) {
            addCriterion("aad_be_af_flag not between", value1, value2, "aadBeAfFlag");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}